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);
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);
638:
639: ln_legal_employer_id number;
640: l_employer_xml char_tab;
641: ld_effective_date date;
642: lv_gre_name pay_action_information.action_information1%type;
643: lv_trans_gre_name pay_action_information.action_information1%type;
644: lv_paternal_last_name pay_action_information.action_information1%type;
645: lv_employee_name pay_action_information.action_information1%type;
646: lv_location_id pay_action_information.action_information1%type;
639: ln_legal_employer_id number;
640: l_employer_xml char_tab;
641: ld_effective_date date;
642: lv_gre_name pay_action_information.action_information1%type;
643: lv_trans_gre_name pay_action_information.action_information1%type;
644: lv_paternal_last_name pay_action_information.action_information1%type;
645: lv_employee_name pay_action_information.action_information1%type;
646: lv_location_id pay_action_information.action_information1%type;
647: l_proc_name varchar2(100);
640: l_employer_xml char_tab;
641: ld_effective_date date;
642: lv_gre_name pay_action_information.action_information1%type;
643: lv_trans_gre_name pay_action_information.action_information1%type;
644: lv_paternal_last_name pay_action_information.action_information1%type;
645: lv_employee_name pay_action_information.action_information1%type;
646: lv_location_id pay_action_information.action_information1%type;
647: l_proc_name varchar2(100);
648: --l_xml CLOB;
641: ld_effective_date date;
642: lv_gre_name pay_action_information.action_information1%type;
643: lv_trans_gre_name pay_action_information.action_information1%type;
644: lv_paternal_last_name pay_action_information.action_information1%type;
645: lv_employee_name pay_action_information.action_information1%type;
646: lv_location_id pay_action_information.action_information1%type;
647: l_proc_name varchar2(100);
648: --l_xml CLOB;
649:
642: lv_gre_name pay_action_information.action_information1%type;
643: lv_trans_gre_name pay_action_information.action_information1%type;
644: lv_paternal_last_name pay_action_information.action_information1%type;
645: lv_employee_name pay_action_information.action_information1%type;
646: lv_location_id pay_action_information.action_information1%type;
647: l_proc_name varchar2(100);
648: --l_xml CLOB;
649:
650: CURSOR get_archived_info (cp_action_info_id number) IS
654: action_information5,
655: action_information6,
656: action_information7,
657: action_information12
658: FROM pay_action_information
659: WHERE action_information_id = cp_action_info_id;
660:
661: FUNCTION get_param_val (p_param_name varchar2) return varchar2 is
662: BEGIN