[Home] [Help]
PACKAGE: APPS.PAY_GTNLOD_PKG
Source
1 PACKAGE pay_gtnlod_pkg AUTHID CURRENT_USER AS
2 /* $Header: pygtnlod.pkh 120.2.12020000.1 2012/06/28 17:59:31 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 20-APR-2009 kagangul 115.5 Bug# 8363373: Introducing function get_state_name, get_county_name
17 and get_city_name to get the names based on jurisdiction code.
18 This will help distinguishing the City Withheld for same city name
19 but in different state/county.
20 --
21 */
22 TYPE sum_table IS TABLE OF pay_us_rpt_totals%ROWTYPE INDEX BY BINARY_INTEGER;
23 g_totals_table sum_table;
24 l_index number :=0;
25 procedure load_data
26 (
27 pactid in varchar2, /* payroll action id */
28 chnkno in number,
29 ppa_finder in varchar2
30 );
31 /*-- Bug#4942114 starts -- */
32 procedure load_data
33 (
34 p_payroll_action_id number ,
35 p_chunk number,
36 ppa_finder number ,
37 p_ded_bal_status1 varchar2,
38 p_ded_bal_status2 varchar2,
39 p_earn_bal_status varchar2,
40 p_fed_bal_status varchar2,
41 p_state_bal_status varchar2,
42 p_local_bal_status varchar2,
43 p_fed_liab_bal_status varchar2,
44 p_state_liab_bal_status varchar2,
45 p_futa_status_count number,
46 p_futa_def_bal_id number,
47 p_er_liab_status varchar2,
48 p_wc_er_liab_status_count number,
49 p_asg_flag varchar2
50 );
51
52 /*procedure load_data
53 (
54 p_payroll_action_id number ,
55 p_chunk number,
56 ppa_finder number ,
57 p_ded_view_name varchar2 ,
58 p_earn_view_name varchar2 ,
59 p_fed_view_name varchar2 ,
60 p_state_view_name varchar2 ,
61 p_local_view_name varchar2 ,
62 p_fed_liab_view_name varchar2 ,
63 p_state_liab_view_name varchar2 ,
64 p_futa_where varchar2,
65 p_futa_from varchar2,
66 p_er_liab_where varchar2 ,
67 p_er_liab_from varchar2,
68 p_wc_er_liab_where varchar2 ,
69 p_wc_er_liab_from varchar2,
70 p_asg_flag varchar2
71 ); */
72 /*-- Bug#4942114 ends -- */
73
74 /* Bug # 8363373 Start */
75
76 FUNCTION get_state_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
77 RETURN VARCHAR2;
78
79 FUNCTION get_county_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
80 RETURN VARCHAR2;
81
82 FUNCTION get_city_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
83 RETURN VARCHAR2;
84
85 /* Bug # 8363373 End */
86
87 end pay_gtnlod_pkg;