[Home] [Help]
504: BEGIN
505: l_proc_name := g_proc_name || 'GENERATE_XML';
506: hr_utility_trace ('Entering '||l_proc_name);
507:
508: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
509: ('TRANSFER_ACT_ID');
510:
511: hr_utility_trace ('Processing WRI asg action '|| ln_assignment_action_id);
512:
573: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
574: hr_utility_trace ('Entering '||l_proc_name);
575:
576: hr_utility_trace ('Root XML tag = '||
577: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
578:
579: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
580:
581: write_to_magtape_lob (lv_buf);
575:
576: hr_utility_trace ('Root XML tag = '||
577: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
578:
579: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
580:
581: write_to_magtape_lob (lv_buf);
582:
583: hr_utility_trace ('BLOB contents after appending header information');
600: pay_action_interlocks lck_arch,
601: pay_assignment_actions paa_arch,
602: pay_assignment_actions paa_wri
603: WHERE paa_wri.payroll_action_id =
604: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
605: AND lck_sua.locking_action_id = paa_wri.assignment_action_id
606: AND lck_sua.locked_action_id = lck_arch.locking_action_id
607: AND lck_arch.locked_action_id = paa_arch.assignment_action_id
608: AND paa_arch.payroll_action_id = pai.action_context_id
679: lv_buf := lv_buf || '
680: SUBSTR (g_end_date, 1, 4)||'
681:
682: lv_buf := lv_buf || '
683: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),
684: 2);
685:
686: write_to_magtape_lob (lv_buf);
687: