[Home] [Help]
PACKAGE: APPS.PAY_MAG_TAPE
Source
1 package pay_mag_tape as
2 /* $Header: pymagtpe.pkh 120.6.12010000.1 2008/07/27 23:09:03 appldev ship $ */
3 type host_array is table of VARCHAR(81)
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;