APPS.PER_MX_SS_AFFILIATION dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 1142: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

1138: ln_person_id number;
1139: lv_do_not_report varchar2(1);
1140: ld_process_date date;
1141: lt_tran transactions;
1142: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;

Line 1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;

1139: lv_do_not_report varchar2(1);
1140: ld_process_date date;
1141: lt_tran transactions;
1142: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;

Line 1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;

1140: ld_process_date date;
1141: lt_tran transactions;
1142: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1143: lt_act_info_id_per_exc pay_payroll_xml_extract_pkg.int_tab_type;
1144: lt_act_info_id_tran_exc pay_payroll_xml_extract_pkg.int_tab_type;
1145: lv_person_id pay_action_information.action_information1%type;
1146: lv_name pay_action_information.action_information7%type;
1147: lv_worker_type pay_action_information.action_information8%type;
1148: lv_rww pay_action_information.action_information9%type;

Line 1316: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1312: lt_act_info_id_tran_exc.count() = 0 AND
1313: lt_act_info_id_per_exc.count() = 0 THEN
1314: hr_utility_trace ('Nothing to write to XML BLOB.');
1315: ELSE
1316: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1317: NULL,
1318: g_document_type,
1319: l_xml);
1320: write_to_magtape_lob (l_xml);

Line 1323: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_tran_exc,

1319: l_xml);
1320: write_to_magtape_lob (l_xml);
1321:
1322: hr_utility_trace ('Attempting to generate XML for transaction exceptions.');
1323: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_tran_exc,
1324: 'TRANS_EXCEPTION',
1325: g_document_type,
1326: l_xml);
1327: write_to_magtape_lob (l_xml);

Line 1330: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_per_exc,

1326: l_xml);
1327: write_to_magtape_lob (l_xml);
1328:
1329: hr_utility_trace ('Attempting to generate XML for person exceptions.');
1330: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_per_exc,
1331: 'PERSON_EXCEPTION',
1332: g_document_type,
1333: l_xml);
1334: write_to_magtape_lob (l_xml);

Line 1396: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

1392:
1393: l_proc_name varchar2(100);
1394: lv_buf varchar2(8000);
1395: l_xml BLOB;
1396: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1397: BEGIN
1398: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
1399: hr_utility_trace ('Entering '||l_proc_name);
1400:

Line 1405: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1401: OPEN csr_employer;
1402: FETCH csr_employer INTO lt_act_info_id(lt_act_info_id.count());
1403: CLOSE csr_employer;
1404:
1405: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1406: NULL,
1407: g_document_type,
1408: l_xml);
1409: write_to_magtape_lob (l_xml);