[Home] [Help]
995: paf.assignment_id*/;
996:
997: CURSOR csr_asg_actions (cp_person_id number) IS
998: /*SELECT fnd_number.canonical_to_number(
999: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
1000: fnd_date.canonical_to_date (g_end_date)
1001: FROM dual
1002: UNION
1003: SELECT paa.assignment_action_id,
1166: BEGIN
1167: l_proc_name := g_proc_name || 'GENERATE_XML';
1168: hr_utility_trace ('Entering '||l_proc_name);
1169:
1170: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1171: ('TRANSFER_ACT_ID');
1172:
1173: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1174: hr_utility_trace ('g_start_date '|| g_start_date);
1353: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1354: hr_utility_trace ('Entering '||l_proc_name);
1355:
1356: hr_utility_trace ('Root XML tag = '||
1357: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1358:
1359: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1360:
1361: write_to_magtape_lob (lv_buf);
1355:
1356: hr_utility_trace ('Root XML tag = '||
1357: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1358:
1359: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1360:
1361: write_to_magtape_lob (lv_buf);
1362:
1363: hr_utility_trace ('BLOB contents after appending header information');
1379: pay_action_interlocks lck,
1380: pay_assignment_actions paa_affl,
1381: pay_assignment_actions paa_arch
1382: WHERE paa_affl.payroll_action_id =
1383: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
1384: AND lck.locking_action_id = paa_affl.assignment_action_id
1385: AND paa_arch.assignment_action_id = lck.locked_action_id
1386: AND pai.action_context_id = paa_arch.payroll_action_id
1387: --AND pai.action_information2 = pai.action_information4
1408: l_xml);
1409: write_to_magtape_lob (l_xml);
1410:
1411: lv_buf := lv_buf || '' ||
1412: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),
1413: 2);
1414:
1415: write_to_magtape_lob (lv_buf);
1416: