[Home] [Help]
PACKAGE: APPS.PAY_AU_PAYSUM_ALLOWANCE
Source
1 package pay_au_paysum_allowance AUTHID CURRENT_USER as
2 /* $Header: pyaupsalw.pkh 120.1 2011/11/07 03:07:17 skshin ship $*/
3 /*
4 *** ------------------------------------------------------------------------+
5 *** Date Changed By Version Bug No Description of Change
6 *** --------- ---------- ------- ------ --------------------------------+
7 *** 18 DEC 08 skshin 115.0 7571001 Initial Version
8 *** 23 DEC 08 skshin 115.1 7571001 added Validate/Transfer mode
9 *** 23 DEC 08 skshin 115.3 7571001 Broken into small procedures
10 *** 04 NOV 11 skshin 121.2 13043109 Added upgrade_AU_address_style procedure
11 *** ------------------------------------------------------------------------+
12 */
13
14 TYPE recd_allowance_balance IS RECORD ( balance_name pay_balance_types.balance_name%type
15 ,defined_balance_id pay_defined_balances.defined_balance_id%type
16 ,balance_type_id pay_balance_types.balance_type_id%type);
17 TYPE tab_allowance_balance IS TABLE OF recd_allowance_balance INDEX BY BINARY_INTEGER;
18 t_allowance_balance tab_allowance_balance;
19 tl_allowance_balance tab_allowance_balance;
20
21 procedure upgrade_allowance_bar(
22 errbuf out NOCOPY varchar2,
23 retcode out NOCOPY varchar2,
24 p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
25 p_mode in varchar2
26 );
27
28 procedure upgrade_ba (
29 p_cnt in number,
30 p_allowance_balance in tab_allowance_balance,
31 p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
32 p_mode in varchar2
33 );
34
35 procedure upgrade_glr (
36 p_t_allowance_balance in tab_allowance_balance,
37 p_tl_allowance_balance in tab_allowance_balance,
38 p_business_group_name in per_business_groups.name%type,
39 p_mode in varchar2
40 ) ;
41
42 procedure check_run (
43 p_t_allowance_balance in tab_allowance_balance,
44 p_tl_allowance_balance in tab_allowance_balance,
45 p_mode in varchar2
46 ) ;
47
48 procedure upgrade_AU_address_style (
49 errbuf out NOCOPY varchar2,
50 retcode out NOCOPY varchar2,
51 p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
52 p_mode in varchar2
53 );
54
55 END pay_au_paysum_allowance;