1 package pycadar_pkg AUTHID CURRENT_USER as
2 /* $Header: pycadar.pkh 120.0.12020000.2 2012/07/04 21:40:43 amnaraya ship $ */
3 /*
4
5 rem +======================================================================+
6 rem | Copyright (c) 1993 Oracle Corporation |
7 rem | Redwood Shores, California, USA |
8 rem | All rights reserved. |
9 rem +======================================================================+
10 Change List
11 -----------
12 Date Name Vers Description
13 ----------- ---------- ----- -----------------------------------
14 03-JUN-1999 mmukherj 110.0 Created.
15 23-MAR-2001 vpandya 115.1 Added get_labels function
16 with three input parameters.
17 09-MAY-2002 vpandya 115.2 Added dbdrv and checkfile
18 04-JUN-2002 vpandya 115.4 Added procedure archive_action_creation for
19 the deposit advice process that runs off of
20 the payroll archive process.
21 21-SEP-2002 pganguly 115.5 Added whenever oserror exit failure rollback
22 27-Jan-2003 vpandya 115.6 Added nocopy with out parameter as per gscc.
23 27-JUL-2004 ssattini 115.7 Added new function check_if_assignment_paid
24 to use in the archive_action_creation
25 procedure to improve performance. Bug#3438254
26 05-MAR-2012 sgotlasw 115.8 " CANADIAN DEPOSIT ADVICE (XML) ENHANCEMENT "
27 Added following methods and set of new variables.
28 qualifying_proc
29 check_if_qualified_for_CA
30 --
31 */
32 procedure range_cursor ( pactid in number,
33 sqlstr out nocopy varchar2
34 );
35
36 FUNCTION check_if_assignment_paid(p_prepayment_action_id in number,
37 p_deposit_start_date in date,
38 p_deposit_end_date in date,
39 p_consolidation_set_id in number)
40 RETURN VARCHAR2;
41
42 procedure action_creation ( pactid in number,
43 stperson in number,
44 endperson in number,
45 chunk in number
46 );
47
48 procedure archive_action_creation ( pactid in number,
49 stperson in number,
50 endperson in number,
51 chunk in number
52 );
53
54 procedure sort_action ( procname in varchar2,
55 sqlstr in out nocopy varchar2,
56 len out nocopy number
57 );
58
59 function get_parameter(name in varchar2,
60 parameter_list varchar2) return varchar2;
61 pragma restrict_references(get_parameter, WNDS, WNPS);
62
63 function get_labels(p_lookup_type in varchar2,
64 p_lookup_code in varchar2) return varchar2;
65
66 function get_labels(p_lookup_type in varchar2,
67 p_lookup_code in varchar2,
68 p_person_language in varchar2 ) return varchar2;
69
70 --pragma restrict_references(get_labels, WNDS, WNPS);
71
72 /* Bug 13773865: CANADIAN DEPOSIT ADVICE (XML) ENHANCEMENT
73 Added following 2 methods.
74 qualifying_proc
75 check_if_qualified_for_CA
76 */
77
78 PROCEDURE qualifying_proc(p_assignment_id IN NUMBER
79 ,p_qualifier OUT NOCOPY VARCHAR2 ) ;
80 --
81 --
82 FUNCTION check_if_qualified_for_CA(p_archive_action_id IN NUMBER
83 ,p_assignment_id IN NUMBER
84 ,p_deposit_start_date IN DATE
85 ,p_deposit_end_date IN DATE
86 ,p_consolidation_set_id IN NUMBER)
87 RETURN VARCHAR2;
88
89 /* Bug 13773865: CANADIAN DEPOSIT ADVICE (XML) ENHANCEMENT
90 Added following set of new variables.
91 */
92 TYPE typ_tmp_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
93 g_tmp_tbl typ_tmp_tbl;
94
95 g_payroll_act_id NUMBER := -1;
96 g_payroll_id NUMBER := -1;
97 g_consolidation_set_id NUMBER := -1;
98 g_start_dt DATE := TO_DATE('0001/01/01','YYYY/MM/DD');
99 g_end_dt DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
100 g_rep_group pay_report_groups.report_group_name%TYPE := NULL;
101 g_rep_category pay_report_categories.category_name%TYPE := NULL;
102 g_assignment_set_id NUMBER := -1;
103 g_assignment_id NUMBER := -1;
104 g_effective_date DATE := TO_DATE('0001/01/01','YYYY/MM/DD');
105 g_business_group_id NUMBER := -1;
106 g_legislation_code VARCHAR2(10) := 'XX';
107
108
109 end pycadar_pkg;