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 890: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

886: lv_per_do_not_report varchar2(1);
887: lv_tran_do_not_report varchar2(1);
888: l_xml BLOB;
889: lb_person_processed boolean;
890: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
891: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;
892: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;
893: lt_tran per_mx_ss_affiliation.transactions;
894: ln_legal_er NUMBER;

Line 891: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;

887: lv_tran_do_not_report varchar2(1);
888: l_xml BLOB;
889: lb_person_processed boolean;
890: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
891: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;
892: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;
893: lt_tran per_mx_ss_affiliation.transactions;
894: ln_legal_er NUMBER;
895: ld_imp_date varchar2(30);

Line 892: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;

888: l_xml BLOB;
889: lb_person_processed boolean;
890: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
891: lt_act_info_id_exc_wd pay_payroll_xml_extract_pkg.int_tab_type;
892: lt_act_info_id_exc_trans pay_payroll_xml_extract_pkg.int_tab_type;
893: lt_tran per_mx_ss_affiliation.transactions;
894: ln_legal_er NUMBER;
895: ld_imp_date varchar2(30);
896: ld_event_strt_date VARCHAR2 (30);

Line 1135: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1131: lt_act_info_id_exc_trans.count() = 0 THEN
1132: hr_utility_trace ('Nothing to write to BLOB for magtape asg action '||
1133: ln_assignment_action_id);
1134: ELSE
1135: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1136: NULL,
1137: g_document_type,
1138: l_xml);
1139: write_to_magtape_lob (l_xml);

Line 1141: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_wd,

1137: g_document_type,
1138: l_xml);
1139: write_to_magtape_lob (l_xml);
1140:
1141: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_wd,
1142: 'WD_EXCEPTION',
1143: g_document_type,
1144: l_xml);
1145: write_to_magtape_lob (l_xml);

Line 1147: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_trans,

1143: g_document_type,
1144: l_xml);
1145: write_to_magtape_lob (l_xml);
1146:
1147: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_exc_trans,
1148: 'TRANS_EXCEPTION',
1149: g_document_type,
1150: l_xml);
1151: write_to_magtape_lob (l_xml);

Line 1219: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

1215: WHERE pai.action_context_id = cp_action_context_id
1216: AND pai.action_context_type = 'PA'
1217: AND pai.action_information_category = 'MX SS GRE INFORMATION';
1218:
1219: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1220: ln_pact_id number;
1221: l_xml BLOB;
1222: l_proc_name varchar2(100);
1223: ln_chars number;

Line 1247: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,

1243: IF lt_act_info_id.count() = 0 THEN
1244: hr_utility_trace('GRE Information not found for magtape payroll action '
1245: || pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'));
1246: ELSE
1247: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1248: NULL,
1249: g_document_type,
1250: l_xml);
1251: