APPS.PAY_MX_SUA_MAG dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 57: pay_payroll_xml_extract_pkg.

53: sdahiya 10-Aug-2005 115.11 Re-initialized global variables
54: in GEN_XML_FOOTER.
55: sdahiya 19-Aug-2005 115.12 Added document_type parameter in
56: calls to
57: pay_payroll_xml_extract_pkg.
58: generate.
59: vpandya 31-Oct-2005 115.13 4710619 Changed cursor get_emp_trans,
60: using action_information5 in
61: place of effective_date in

Line 1005: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

1001: lv_per_do_not_report varchar2(1);
1002: lv_tran_do_not_report varchar2(1);
1003: l_xml BLOB;
1004: lb_person_processed boolean;
1005: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1006: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;
1007: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;
1008: lt_tran per_mx_ss_affiliation.transactions;
1009: ln_legal_er NUMBER;

Line 1006: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;

1002: lv_tran_do_not_report varchar2(1);
1003: l_xml BLOB;
1004: lb_person_processed boolean;
1005: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1006: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;
1007: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;
1008: lt_tran per_mx_ss_affiliation.transactions;
1009: ln_legal_er NUMBER;
1010: ld_imp_date varchar2(30);

Line 1007: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;

1003: l_xml BLOB;
1004: lb_person_processed boolean;
1005: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1006: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;
1007: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;
1008: lt_tran per_mx_ss_affiliation.transactions;
1009: ln_legal_er NUMBER;
1010: ld_imp_date varchar2(30);
1011: ld_event_strt_date VARCHAR2 (30);

Line 1263: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1259: lt_act_info_id_exc_trans.count() = 0 THEN
1260: hr_utility_trace ('Nothing to write to BLOB for magtape asg action '||
1261: ln_assignment_action_id);
1262: ELSE
1263: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1264: NULL,
1265: g_document_type,
1266: l_xml);
1267: write_to_magtape_lob (l_xml);

Line 1269: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_wd,

1265: g_document_type,
1266: l_xml);
1267: write_to_magtape_lob (l_xml);
1268:
1269: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_wd,
1270: 'WD_EXCEPTION',
1271: g_document_type,
1272: l_xml);
1273: write_to_magtape_lob (l_xml);

Line 1275: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_trans,

1271: g_document_type,
1272: l_xml);
1273: write_to_magtape_lob (l_xml);
1274:
1275: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_trans,
1276: 'TRANS_EXCEPTION',
1277: g_document_type,
1278: l_xml);
1279: write_to_magtape_lob (l_xml);

Line 1347: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

1343: WHERE pai.action_context_id = cp_action_context_id
1344: AND pai.action_context_type = 'PA'
1345: AND pai.action_information_category = 'MX SS GRE INFORMATION';
1346:
1347: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1348: ln_pact_id number;
1349: l_xml BLOB;
1350: l_proc_name varchar2(100);
1351: ln_chars number;

Line 1375: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1371: IF lt_act_info_id.count() = 0 THEN
1372: hr_utility_trace('GRE Information not found for magtape payroll action '
1373: || pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'));
1374: ELSE
1375: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1376: NULL,
1377: g_document_type,
1378: l_xml);
1379: