APPS.PER_MX_SS_AFFILIATION dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 986: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

982: ln_person_id number;
983: lv_do_not_report varchar2(1);
984: ld_process_date date;
985: lt_tran transactions;
986: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;

Line 987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;

983: lv_do_not_report varchar2(1);
984: ld_process_date date;
985: lt_tran transactions;
986: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;

Line 988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;

984: ld_process_date date;
985: lt_tran transactions;
986: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
987: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
988: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
989: lv_person_id pay_action_information.action_information1%type;
990: lv_name pay_action_information.action_information7%type;
991: lv_worker_type pay_action_information.action_information8%type;
992: lv_rww pay_action_information.action_information9%type;

Line 1141: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1137: lt_act_info_id_tran_exc.count() = 0 AND
1138: lt_act_info_id_per_exc.count() = 0 THEN
1139: hr_utility_trace ('Nothing to write to XML BLOB.');
1140: ELSE
1141: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1142: NULL,
1143: g_document_type,
1144: l_xml);
1145: write_to_magtape_lob (l_xml);

Line 1148: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_tran_exc,

1144: l_xml);
1145: write_to_magtape_lob (l_xml);
1146:
1147: hr_utility_trace ('Attempting to generate XML for transaction exceptions.');
1148: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_tran_exc,
1149: 'TRANS_EXCEPTION',
1150: g_document_type,
1151: l_xml);
1152: write_to_magtape_lob (l_xml);

Line 1155: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_per_exc,

1151: l_xml);
1152: write_to_magtape_lob (l_xml);
1153:
1154: hr_utility_trace ('Attempting to generate XML for person exceptions.');
1155: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_per_exc,
1156: 'PERSON_EXCEPTION',
1157: g_document_type,
1158: l_xml);
1159: write_to_magtape_lob (l_xml);

Line 1221: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

1217:
1218: l_proc_name varchar2(100);
1219: lv_buf varchar2(8000);
1220: l_xml BLOB;
1221: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1222: BEGIN
1223: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
1224: hr_utility_trace ('Entering '||l_proc_name);
1225:

Line 1230: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1226: OPEN csr_employer;
1227: FETCH csr_employer INTO lt_act_info_id(lt_act_info_id.count());
1228: CLOSE csr_employer;
1229:
1230: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1231: NULL,
1232: g_document_type,
1233: l_xml);
1234: write_to_magtape_lob (l_xml);