APPS.PAY_MX_RULES dependencies on PAY_ACTION_INFORMATION

Line 31: l_data pay_action_information.action_information1%type;

27: PROCEDURE LOAD_XML (
28: P_XML varchar2
29: ) AS
30: l_proc_name varchar2(100);
31: l_data pay_action_information.action_information1%type;
32:
33: BEGIN
34: l_proc_name := g_proc_name || 'LOAD_XML';
35: hr_utility_trace ('Entering '||l_proc_name);

Line 52: l_data pay_action_information.action_information1%type;

48: P_NODE varchar2,
49: P_DATA varchar2
50: ) AS
51: l_proc_name varchar2(100);
52: l_data pay_action_information.action_information1%type;
53:
54: BEGIN
55: l_proc_name := g_proc_name || 'PREPARE_XML';
56: hr_utility_trace ('Entering '||l_proc_name);

Line 661: lv_gre_name pay_action_information.action_information1%type;

657:
658: ln_legal_employer_id number;
659: l_employer_xml char_tab;
660: ld_effective_date date;
661: lv_gre_name pay_action_information.action_information1%type;
662: lv_trans_gre_name pay_action_information.action_information1%type;
663: lv_paternal_last_name pay_action_information.action_information1%type;
664: lv_employee_name pay_action_information.action_information1%type;
665: lv_location_id pay_action_information.action_information1%type;

Line 662: lv_trans_gre_name pay_action_information.action_information1%type;

658: ln_legal_employer_id number;
659: l_employer_xml char_tab;
660: ld_effective_date date;
661: lv_gre_name pay_action_information.action_information1%type;
662: lv_trans_gre_name pay_action_information.action_information1%type;
663: lv_paternal_last_name pay_action_information.action_information1%type;
664: lv_employee_name pay_action_information.action_information1%type;
665: lv_location_id pay_action_information.action_information1%type;
666: l_proc_name varchar2(100);

Line 663: lv_paternal_last_name pay_action_information.action_information1%type;

659: l_employer_xml char_tab;
660: ld_effective_date date;
661: lv_gre_name pay_action_information.action_information1%type;
662: lv_trans_gre_name pay_action_information.action_information1%type;
663: lv_paternal_last_name pay_action_information.action_information1%type;
664: lv_employee_name pay_action_information.action_information1%type;
665: lv_location_id pay_action_information.action_information1%type;
666: l_proc_name varchar2(100);
667: --l_xml CLOB;

Line 664: lv_employee_name pay_action_information.action_information1%type;

660: ld_effective_date date;
661: lv_gre_name pay_action_information.action_information1%type;
662: lv_trans_gre_name pay_action_information.action_information1%type;
663: lv_paternal_last_name pay_action_information.action_information1%type;
664: lv_employee_name pay_action_information.action_information1%type;
665: lv_location_id pay_action_information.action_information1%type;
666: l_proc_name varchar2(100);
667: --l_xml CLOB;
668:

Line 665: lv_location_id pay_action_information.action_information1%type;

661: lv_gre_name pay_action_information.action_information1%type;
662: lv_trans_gre_name pay_action_information.action_information1%type;
663: lv_paternal_last_name pay_action_information.action_information1%type;
664: lv_employee_name pay_action_information.action_information1%type;
665: lv_location_id pay_action_information.action_information1%type;
666: l_proc_name varchar2(100);
667: --l_xml CLOB;
668:
669: CURSOR get_archived_info (cp_action_info_id number) IS

Line 677: FROM pay_action_information

673: action_information5,
674: action_information6,
675: action_information7,
676: action_information12
677: FROM pay_action_information
678: WHERE action_information_id = cp_action_info_id;
679:
680: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
681: BEGIN