[Home] [Help]
PACKAGE: APPS.PQP_USTIAA_PKG
Source
1 PACKAGE pqp_ustiaa_pkg AUTHID CURRENT_USER as
2 /* $Header: pqustiaa.pkh 120.1.12000000.1 2007/01/16 04:38:44 appldev noship $ */
3 /*
4
5 --
6 */
7
8 level_cnt number;
9
10 PROCEDURE range_cursor ( pactid in number ,
11 sqlstr out nocopy varchar2
12 );
13 PROCEDURE action_creation ( pactid in number ,
14 stperson in number ,
15 endperson in number,
16 chunk in number
17 );
18 PROCEDURE sort_action ( payactid in varchar2 ,
19 sqlstr in out nocopy varchar2 ,
20 len out nocopy number
21 );
22 FUNCTION get_parameter(name in varchar2 ,
23 parameter_list varchar2) return varchar2;
24 PRAGMA RESTRICT_REFERENCES(get_parameter, WNDS, WNPS);
25 --
26
27 PROCEDURE action_creation_ops ( pactid in number ,
28 stperson in number ,
29 endperson in number,
30 chunk in number
31 );
32
33 PROCEDURE generate_record;
34
35 PROCEDURE generate_header_xml;
36
37 PROCEDURE generate_footer_xml;
38
39 CURSOR TIAA_DETAIL IS
40 SELECT 'TRANSFER_ACT_ID=P'
41 , ptoa.object_action_id
42 FROM pay_temp_object_actions ptoa
43 WHERE ptoa.payroll_action_id =
44 pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
45
46 CURSOR TIAA_HF IS
47 SELECT 'PAYROLL_ACTION_ID=P'
48 ,pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
49 FROM dual;
50
51 CURSOR TIAA_ASG_ACTIONS IS
52 SELECT 'TRANSFER_ACT_ID=P'
53 ,pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
54 FROM dual;
55
56 END pqp_ustiaa_pkg;