PACKAGE: APPS.PAY_MAG_TAPE

Source

1 package pay_mag_tape AUTHID CURRENT_USER as
2 /* $Header: pymagtpe.pkh 120.6.12020000.2 2013/01/10 11:17:20 pracagra ship $ */
3    type host_array is table of VARCHAR(240)    -- Bug# 16008268 Gre length issue
4          index by binary_integer;
5    internal_prm_names host_array;
6    internal_prm_values host_array;
7    internal_cxt_names host_array;
8    internal_cxt_values host_array;
9    internal_xml_names host_array;
10    internal_xml_values host_array;
11 
12    mag_file varchar2(240);
13    rep_file varchar2(240);
14    pay_top varchar2(100);
15    g_blob_value blob;
16    g_blob_file_id number;
17 
18    procedure run_proc(comm IN varchar2);
19    procedure run_xml_proc(comm in varchar2,
20                          source_id in number,
21                          source_type in varchar2,
22                          file_name in varchar2,
23  			 sequence in number);
24 
25 procedure call_leg_xml_proc;
26 
27 
28 cursor c_asg_actions
29 IS
30 SELECT 'TRANSFER_ACT_ID=P', paa.object_action_id
31 FROM   pay_temp_object_actions paa
32 WHERE  paa.payroll_action_id =
33          pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
34 
35 cursor c_header_footer
36 is
37 SELECT 'BG_ID=P', ppa.business_group_id
38 from pay_payroll_actions ppa
39 WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
40                               ('TRANSFER_PAYROLL_ACTION_ID');
41 
42 cursor c_asg_details
43 is
44 SELECT 'ASG_ID=P', paa.object_id
45 FROM   pay_temp_object_actions paa
46 WHERE  paa.object_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
47 
48 level_cnt number;
49 
50 end pay_mag_tape;