[Home] [Help]
845: paf.assignment_id*/;
846:
847: CURSOR csr_asg_actions (cp_person_id number) IS
848: /*SELECT fnd_number.canonical_to_number(
849: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
850: fnd_date.canonical_to_date (g_end_date)
851: FROM dual
852: UNION
853: SELECT paa.assignment_action_id,
1005: BEGIN
1006: l_proc_name := g_proc_name || 'GENERATE_XML';
1007: hr_utility_trace ('Entering '||l_proc_name);
1008:
1009: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1010: ('TRANSFER_ACT_ID');
1011:
1012: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1013: hr_utility_trace ('g_start_date '|| g_start_date);
1178: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1179: hr_utility_trace ('Entering '||l_proc_name);
1180:
1181: hr_utility_trace ('Root XML tag = '||
1182: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1183:
1184: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1185:
1186: write_to_magtape_lob (lv_buf);
1180:
1181: hr_utility_trace ('Root XML tag = '||
1182: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1183:
1184: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1185:
1186: write_to_magtape_lob (lv_buf);
1187:
1188: hr_utility_trace ('BLOB contents after appending header information');
1204: pay_action_interlocks lck,
1205: pay_assignment_actions paa_affl,
1206: pay_assignment_actions paa_arch
1207: WHERE paa_affl.payroll_action_id =
1208: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
1209: AND lck.locking_action_id = paa_affl.assignment_action_id
1210: AND paa_arch.assignment_action_id = lck.locked_action_id
1211: AND pai.action_context_id = paa_arch.payroll_action_id
1212: --AND pai.action_information2 = pai.action_information4
1233: l_xml);
1234: write_to_magtape_lob (l_xml);
1235:
1236: lv_buf := lv_buf || '
1237: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),
1238: 2);
1239:
1240: write_to_magtape_lob (lv_buf);
1241: