APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_ACTION_INFORMATION

Line 23: in pay_action_information. Calling applications can invoke

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

Line 95: g_custom_context pay_action_information.action_information_category%type;

91:
92: g_proc_name varchar2(50);
93: g_debug boolean;
94: g_action_ctx_id number;
95: g_custom_context pay_action_information.action_information_category%type;
96:
97:
98: /****************************************************************************
99: Name : HR_UTILITY_TRACE

Line 133: l_data pay_action_information.action_information1%type;

129: P_NODE varchar2,
130: P_DATA varchar2
131: ) AS
132: l_proc_name varchar2(100);
133: l_data pay_action_information.action_information1%type;
134:
135: BEGIN
136: l_proc_name := g_proc_name || 'LOAD_XML_INTERNAL';
137: hr_utility_trace ('Entering '||l_proc_name);

Line 219: l_data pay_action_information.action_information1%type;

215:
216: l_proc_name varchar2(100);
217: l_tag_name varchar2(500);
218: l_chk_no pay_assignment_actions.serial_number%type;
219: l_data pay_action_information.action_information1%type;
220:
221: BEGIN
222: l_proc_name := g_proc_name || 'LOAD_XML';
223: hr_utility_trace ('Entering '||l_proc_name);

Line 348: P_XML pay_action_information.action_information1%type

344: LOAD_XML_DATA should be used if such validations are required
345: to be performed implicitly.
346: *****************************************************************************/
347: PROCEDURE LOAD_XML (
348: P_XML pay_action_information.action_information1%type
349: ) AS
350:
351: l_proc_name varchar2(100);
352:

Line 494: FROM pay_action_information

490: AND hoi1.org_information1 = 'HR_BG'
491: AND hoi2.org_information_context = 'Business Group Information'
492: AND ppa.action_type = 'X'
493: AND NVL (p_action_context_id, (SELECT action_context_id
494: FROM pay_action_information
495: WHERE action_information_id =
496: p_action_information_id))
497: = paa.assignment_action_id;
498:

Line 501: FROM pay_action_information

497: = paa.assignment_action_id;
498:
499: CURSOR csr_get_archived_regions IS
500: SELECT DISTINCT action_information_category
501: FROM pay_action_information
502: WHERE ((action_context_type = 'AAP'
503: AND action_context_id = p_action_context_id)
504: OR (action_context_type = 'PA'
505: AND action_context_id =