PACKAGE: APPS.PAY_GTNLOD_PKG

Source

1 PACKAGE pay_gtnlod_pkg AS
2 /* $Header: pygtnlod.pkh 120.1.12010000.1 2008/07/27 22:48:01 appldev ship $ */
3 /*
4    Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5 --
6    Name        :This package defines the cursors needed for GTN to run Multi-Threaded
7 --
8    Change List
9    -----------
10    Date         Name        Vers   Description
11    -----------  ----------  -----  -----------------------------------
12    21-NOV-1999  ssarma      40.0   created
13    17-MAY-2002  ahanda      115.1  Added dbdrv.
14    09-DEC-2004  sgajula     115.3  Overloaded load_date and changed signatures of other procedures for implementing BRA
15    16-OCT-2006  jdevasah    115.4  Bug 4942114: Input parameters to load_data procedure are changed.
16 --
17 */
18 TYPE sum_table IS TABLE OF pay_us_rpt_totals%ROWTYPE INDEX BY BINARY_INTEGER;
19 g_totals_table sum_table;
20 l_index   number :=0;
21 procedure load_data
22 (
23    pactid   in     varchar2,     /* payroll action id */
24    chnkno   in     number,
25    ppa_finder in varchar2
26 );
27 /*-- Bug#4942114 starts -- */
28 procedure load_data
29 (
30 	p_payroll_action_id number ,
31 	p_chunk   number,
32 	ppa_finder number ,
33 	p_ded_bal_status1 varchar2,
34 	p_ded_bal_status2 varchar2,
35 	p_earn_bal_status varchar2,
36 	p_fed_bal_status varchar2,
37 	p_state_bal_status varchar2,
38 	p_local_bal_status varchar2,
39 	p_fed_liab_bal_status varchar2,
40 	p_state_liab_bal_status varchar2,
41 	p_futa_status_count number,
42 	p_futa_def_bal_id number,
43 	p_er_liab_status varchar2,
44 	p_wc_er_liab_status_count number,
45 	p_asg_flag varchar2
46 );
47 
48 /*procedure load_data
49 (
50 	p_payroll_action_id number ,
51 	p_chunk   number,
52 	ppa_finder number ,
53 	p_ded_view_name varchar2 ,
54 	p_earn_view_name varchar2 ,
55 	p_fed_view_name varchar2  ,
56 	p_state_view_name varchar2  ,
57 	p_local_view_name varchar2 ,
58 	p_fed_liab_view_name varchar2 ,
59 	p_state_liab_view_name varchar2 ,
60 	p_futa_where varchar2,
61 	p_futa_from varchar2,
62 	p_er_liab_where varchar2 ,
63 	p_er_liab_from varchar2,
64 	p_wc_er_liab_where varchar2 ,
65 	p_wc_er_liab_from varchar2,
66 	p_asg_flag varchar2
67 ); */
68 /*-- Bug#4942114 ends -- */
69 end pay_gtnlod_pkg;