PACKAGE: APPS.PAY_CA_MAG_ROE

Source

1 package pay_ca_mag_roe AUTHID CURRENT_USER as
2 /* $Header: pycaremg.pkh 115.2 2004/01/19 17:55:03 pganguly noship $ */
3 
4 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
5                                   INDEX BY BINARY_INTEGER;
6 level_cnt	number;
7 
8 cursor cur_mag_roe is
9 select 'ASSIGNMENT_ACTION_ID=C', pai.locked_action_id
10 from
11 	pay_assignment_actions paa,
12 	pay_payroll_actions    ppa,
13 	pay_action_interlocks  pai
14 where
15 	ppa.payroll_action_id=pay_magtape_generic.get_parameter_value
16 				('TRANSFER_PAYROLL_ACTION_ID') and
17 	ppa.payroll_action_id=paa.payroll_action_id and
18 	paa.assignment_action_id= pai.locking_action_id;
19 
20 
21 procedure range_cursor(p_pactid in  number,
22                        p_sqlstr out nocopy varchar2);
23 
24 procedure create_assignment_act(p_pactid in number,
25                           p_stperson in number,
26                           p_endperson in number,
27                           p_chunk in number);
28 
29 end pay_ca_mag_roe;