PACKAGE: APPS.PAY_MX_ISR_FORMAT37_INFO

Source

1 PACKAGE PAY_MX_ISR_FORMAT37_INFO AUTHID CURRENT_USER as
2 /* $Header: paymxformat37dt.pkh 120.1.12000000.1 2007/01/17 14:14:50 appldev noship $ */
3 
4   FUNCTION create_xml_string (p_arch_payroll_action_id NUMBER,
5                               p_arch_person_id         NUMBER,
6                               p_legal_employer_id      NUMBER,
7                               p_year                   NUMBER,
8                               p_pai_eff_date           DATE  )
9   RETURN CLOB;
10 
11   CURSOR main_block  IS
12         SELECT 'Version_Number=X' ,'Version 1.1'
13         FROM   sys.dual;
14 
15   CURSOR Transfer_Block  IS
16     SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
17     FROM   pay_assignment_actions paa
18     WHERE  paa.payroll_action_id =
19          pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
20 
21 
22   CURSOR c_get_asg_action IS
23      SELECT 'TRANSFER_ACT_ID=P',
24            pay_magtape_generic.get_parameter_value(
25                                                 'TRANSFER_ACT_ID')
26       FROM DUAL;
27 
28   PROCEDURE get_headers ;
29   PROCEDURE get_footers;
30   PROCEDURE fetch_format37_xml;
31 
32   level_cnt   NUMBER :=0;
33 
34 END PAY_MX_ISR_FORMAT37_INFO;