[Home] [Help]
19:
20: Name : pay_payroll_xml_extract_pkg
21:
22: Description : This package handles generation of XML from data archived
23: in pay_action_information. Calling applications can invoke
24: one of the overloaded versions of GENERATE procedure with
25: appropriate parameters to obtain the XML. This package has
26: other public procedures which GENERATE uses for processing.
27: They might not be of much use if invoked directly by calling
58: archived_info cursor
59: *****************************************************************************/
60:
61: TYPE int_tab_type IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
62: TYPE char_tab_type IS TABLE OF pay_action_information.action_information1%type
63: INDEX BY BINARY_INTEGER;
64: TYPE param_rec IS RECORD (
65: parameter_name varchar2(50),
66: parameter_value varchar2(500)
135: LOAD_XML_DATA should be used if such validations are required
136: to be performed implicitly.
137: *****************************************************************************/
138: PROCEDURE LOAD_XML (
139: P_XML pay_action_information.action_information1%type
140: );
141:
142:
143: /****************************************************************************
236: action_information27,
237: action_information28,
238: action_information29,
239: action_information30
240: FROM pay_action_information
241: WHERE (action_information_id = p_action_information_id AND p_action_information_id IS NOT NULL)
242: AND action_information_category = p_category
243: UNION ALL /* Bug 6522667, added UNION ALL */
244: SELECT effective_date,
271: action_information27,
272: action_information28,
273: action_information29,
274: action_information30
275: FROM pay_action_information
276: WHERE ((action_context_id = p_action_context_id AND action_context_type = 'AAP') OR
277: (action_context_id = (SELECT payroll_action_id
278: FROM pay_assignment_actions
279: WHERE assignment_action_id = p_action_context_id)