[Home] [Help]
80: cursor mls_req_printers(parent_req_id number,
81: set_program_id number,
82: language varchar2) is
83: select arguments printer, number_of_copies
84: from fnd_run_req_pp_actions
85: where parent_request_id = parent_req_id
86: and request_set_program_id = set_program_id
87: and action_type = 1
88: and (nls_language = language
92: cursor mls_req_notifications(parent_req_id number,
93: set_program_id number,
94: language varchar2) is
95: select arguments notify
96: from fnd_run_req_pp_actions
97: where parent_request_id = parent_req_id
98: and request_set_program_id = set_program_id
99: and action_type = 2
100: and (nls_language = language
104: cursor mls_req_layouts(parent_req_id number,
105: set_program_id number,
106: language varchar2) is
107: select argument1, argument2, argument3, argument4, argument5
108: from fnd_run_req_pp_actions
109: where parent_request_id = parent_req_id
110: and request_set_program_id = set_program_id
111: and action_type = 6
112: and (nls_language = language
115:
116: cursor mls_function_req_layouts(parent_req_id number,
117: set_program_id number) is
118: select argument1, argument2, argument5
119: from fnd_run_req_pp_actions
120: where parent_request_id = parent_req_id
121: and request_set_program_id = set_program_id
122: and action_type = 6
123: order by sequence;
127: set_program_id number,
128: language varchar2) is
129: select argument1, argument2, argument3, argument4, argument5,
130: argument6, argument7, argument8, argument9, argument10
131: from fnd_run_req_pp_actions
132: where parent_request_id = parent_req_id
133: and request_set_program_id = set_program_id
134: and action_type in (7, 8)
135: and (nls_language = language