Button on tool bar to submit concurrent program on tool bar through form personalization

Button on tool bar to submit concurrent program on tool bar through form personalization

To verify Personalization Rules along with Scopes
Seq	Description	Level	Enabled	Trigger Event
20	To Launch Receipt Print Programe - 1	Form	Y	WHEN-NEW-FORM-INSTANCE
25	TO Launch Receipt Print Programe - 2	Form	Y	SPECIAL45
Trigger Object	Condition	Processing Mode	Context Level	Context Value
		Both	User	2,836
		Both	User	2,836

To verify Personalization Rules along with Actions
Seq	Description	Level	Enabled	Trigger Event	Trigger Object	Condition	Processing Mode
20	To Launch Receipt Print Programe - 1	Form	Y	WHEN-NEW-FORM-INSTANCE			Both
25	TO Launch Receipt Print Programe - 2	Form	Y	SPECIAL45			Both
Action Seq	Action Type	Action Description	Action Language	Action Enabled	PROPERTY_VALUE	ARGUMENT_TYPE	TARGET_OBJECT
10	S		*	Y		C
10	B		*	Y		C	RGW_FOLDER.M_TYPE
OBJECT_TYPE	FOLDER_PROMPT_BLOCK	MESSAGE_TYPE	MESSAGE_TEXT	BUILTIN_TYPE	BUILTIN_ARGUMENTS	PROPERTY_NAME	MENU_ENTRY
ITEM		S		C		1,550	SPECIAL45
ITEM		S		C	XXREP:XXMSRCTCL_M	1,550
MENU_LABEL	MENU_SEPERATOR	MENU_ENABLED_IN	MENU_ACTION	MENU_ARGUMENT_LONG	MENU_ARGUMENT_SHORT	ACTION_ID	REQUEST_APPLICATION_ID
To Submit Receipt Printing Programe	N				yellow_circle	95
	N					96

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",

--#########################################################

-- To verify Personalization Rules along with Scopes

--#########################################################    

     DECODE (ffcr.rule_type,

                  'F', 'Form',

                  'A', 'Function',

                  'Other'

                 ) "Level",

          ffcr.enabled "Enabled", ffcr.trigger_event "Trigger Event",

          ffcr.trigger_object "Trigger Object", ffcr.condition "Condition",

          DECODE (ffcr.fire_in_enter_query,

                  'Y', 'Both',

                  'N', 'Not in Enter-Query Mode',

                  'O', 'Only in Enter-Query Mode',

                  'Other'

                 ) "Processing Mode",

          DECODE (ffcs.level_id,

                  '10', 'Industry',

                  '20', 'Site',

                  '30', 'Responsibility',

                  '40', 'User',

                  'Other'

                 ) "Context Level",

          ffcs.level_value "Context Value"

     FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_custom_scopes ffcs

    WHERE 1 = 1

     --AND ffcr.function_name = 'ONT_OEXOEORD'

      AND ffcr.form_name = 'ARXRWMAI'

      AND ffcr.ID = ffcs.rule_id(+)

      AND  ffcr.SEQUENCE IN('20','25')

 ORDER BY ffcr.SEQUENCE, ffcs.level_id;

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",

--#########################################################

 -- To verify Personalization Rules along with Actions

--#########################################################       

 DECODE (ffcr.rule_type,

                  'F', 'Form',

                  'A', 'Function',

                  'Other'

                 ) "Level",

          ffcr.enabled "Enabled", ffcr.trigger_event "Trigger Event",

          ffcr.trigger_object "Trigger Object", ffcr.condition "Condition",

          DECODE (ffcr.fire_in_enter_query,

                  'Y', 'Both',

                  'N', 'Not in Enter-Query Mode',

                  'O', 'Only in Enter-Query Mode',

                  'Other'

                 ) "Processing Mode",

          ffca.SEQUENCE "Action Seq", ffca.action_type "Action Type",

          ffca.summary "Action Description", ffca.LANGUAGE "Action Language",

          ffca.enabled "Action Enabled", ffca.property_value,

          ffca.argument_type, ffca.target_object, ffca.object_type,

          ffca.folder_prompt_block, ffca.MESSAGE_TYPE, ffca.MESSAGE_TEXT,

          ffca.builtin_type, ffca.builtin_arguments, ffca.property_name,

          ffca.menu_entry, ffca.menu_label, ffca.menu_seperator,

          ffca.menu_enabled_in, ffca.menu_action, ffca.menu_argument_long,

          ffca.menu_argument_short, ffca.action_id,

          ffca.request_application_id

     FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_custom_actions ffca

    WHERE 1 = 1

    --and ffcr.function_name = 'ONT_OEXOEORD'

 AND ffcr.form_name = 'ARXRWMAI'

      AND ffcr.ID = ffca.rule_id(+)

      AND  ffcr.SEQUENCE IN('20','25')

 ORDER BY ffcr.SEQUENCE, ffca.SEQUENCE;