APPS.PAY_MX_ANNUAL_WRI dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 501: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

497: ln_assignment_action_id number;
498: ln_act_info_id number;
499: ln_person_id number;
500: lv_do_not_report varchar2(1);
501: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
502: lt_act_info_id_exc pay_payroll_xml_extract_pkg.int_tab_type;
503:
504: BEGIN
505: l_proc_name := g_proc_name || 'GENERATE_XML';

Line 502: lt_act_info_id_exc pay_payroll_xml_extract_pkg.int_tab_type;

498: ln_act_info_id number;
499: ln_person_id number;
500: lv_do_not_report varchar2(1);
501: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
502: lt_act_info_id_exc pay_payroll_xml_extract_pkg.int_tab_type;
503:
504: BEGIN
505: l_proc_name := g_proc_name || 'GENERATE_XML';
506: hr_utility_trace ('Entering '||l_proc_name);

Line 542: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

538: IF lt_act_info_id.count() = 0 AND
539: lt_act_info_id_exc.count() = 0 THEN
540: hr_utility_trace ('No data to write to BLOB.');
541: ELSE
542: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
543: NULL,
544: g_document_type,
545: l_xml);
546: write_to_magtape_lob (l_xml);

Line 548: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc,

544: g_document_type,
545: l_xml);
546: write_to_magtape_lob (l_xml);
547:
548: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc,
549: 'WRI_EXCEPTION',
550: g_document_type,
551: l_xml);
552: write_to_magtape_lob (l_xml);

Line 643: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

639: lv_fax hr_locations.telephone_number_2%type;
640: l_proc_name varchar2(100);
641: lv_buf varchar2(8000);
642: l_xml BLOB;
643: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
644: BEGIN
645: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
646: hr_utility_trace ('Entering '||l_proc_name);
647:

Line 652: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

648: OPEN csr_employer;
649: FETCH csr_employer INTO lt_act_info_id(lt_act_info_id.count());
650: CLOSE csr_employer;
651:
652: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
653: NULL,
654: g_document_type,
655: l_xml);
656: write_to_magtape_lob (l_xml);