PACKAGE: APPS.PQP_USTIAA_PKG

Source

1 PACKAGE  pqp_ustiaa_pkg 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;