1 PACKAGE pay_au_terminations_entry_api AUTHID CURRENT_USER AS
2 /* $Header: pyautapi.pkh 120.9.12020000.2 2012/09/05 01:23:44 skshin ship $
3 **
4 ** Copyright (c) 1999 Oracle Corporation
5 ** All Rights Reserved
6 **
7 ** Procedures and functions used in AU terminations entry form
8 **
9 ** Change List
10 ** ===========
11 **
12 ** Date Author Reference Description
13 ** =========================================================
14 ** 15-NOV-2000 JMHATRE 115.0 Created for AU
15 ** 21-MAR-2002 jkarouza 115.1 Added dbdrv statements.
16 ** 22-MAR-2002 jkarouza 115.2 Added SET VERIFY OFF.
17 ** 04-DEC-2002 Ragovind 115.3 Added NOCOPY for the functions update_al_element_entry, update_etp_element_entry
18 ** ,update_lsl_element_entry,update_super_element_entry
19 **
20 ** 15-May-2003 Ragovind 115.4 Added new parameteres to the procedure update_etp_element_entry for ETP pre/post enhancement.
21 ** 18-May-2003 Ragovind 115.5 Added Bug Reference - Bug#2819479.
22 ** 0-Mar-2006 hnainani 115.5 Added 2 new parameters to update_al_element_entry
23 ** Wrappers for updating the element entries through the
24 ** Terminations form.
25 ** 12-Oct-2006 abhargav 115.8 5592452 Modified to avoid annotation error.
26 ** 24-OCT-2006 hnainani 115.10 5616936 Re-Introduced update_lsl_element_entry parameters
27 ** 09-MAY-2007 priupadh 115.11 5956223 Added New Parameters to update_etp_element_entry
28 ** 04-SEP-2007 priupadh 115.12 6192381 Added New Parameters to update_super_element_entry
29 ** 07-SEP-2007 pmatamsr 115.13 8769345 Added New Parameters to update_super_element_entry
30 ** 12-Nov-2010 avenkatk 115.14 9950136 Added new procedure update_foreign_element_entry
31 ** 05-Sep-2012 skshin 115.15 14358180 Added new parameters to update_etp_element_entry
32 */
33 ---------------------------------------------------------------------------------------
34
35 PROCEDURE update_al_element_entry(p_dt_update_mode IN VARCHAR2
36 ,p_session_date IN DATE
37 ,p_business_group_id IN NUMBER
38 ,p_element_entry_id IN NUMBER
39 ,p_object_version_number IN OUT NOCOPY NUMBER
40 ,p_hours_input_value_id IN NUMBER
41 ,p_payment_input_value_id IN NUMBER
42 ,p_loading_input_value_id IN NUMBER
43 ,p_other_input_value_id IN NUMBER
44 ,p_hours_entry_value IN VARCHAR2
45 ,p_payment_entry_value IN VARCHAR2
46 ,p_loading_entry_value IN VARCHAR2
47 ,p_other_entry_value IN VARCHAR2
48 ,p_effective_start_date IN OUT NOCOPY DATE
49 ,p_effective_end_date IN OUT NOCOPY DATE
50 ,p_update_warning OUT NOCOPY BOOLEAN) ;
51
52 PROCEDURE update_lsl_element_entry(p_dt_update_mode IN VARCHAR2
53 ,p_session_date IN DATE
54 ,p_business_group_id IN NUMBER
55 ,p_element_entry_id IN NUMBER
56 ,p_object_version_number IN OUT NOCOPY NUMBER
57 ,p_pre78_pay_input_value_id IN NUMBER
58 ,p_post78_pay_input_value_id IN NUMBER
59 ,p_post93_pay_input_value_id IN NUMBER
60 ,p_pre78_hours_input_value_id IN NUMBER
61 ,p_post78_hours_input_value_id IN NUMBER
62 ,p_post93_hours_input_value_id IN NUMBER
63 ,p_override_elig_input_value_id IN NUMBER /*Bug# 5056831 */
64 ,p_pre78_pay_entry_value IN VARCHAR2
65 ,p_post78_pay_entry_value IN VARCHAR2
66 ,p_post93_pay_entry_value IN VARCHAR2
67 ,p_pre78_hours_entry_value IN VARCHAR2
68 ,p_post78_hours_entry_value IN VARCHAR2
69 ,p_post93_hours_entry_value IN VARCHAR2
70 ,p_override_elig_entry_value IN VARCHAR2 /*Bug# 5056831 */
71 ,p_effective_start_date IN OUT NOCOPY DATE
72 ,p_effective_end_date IN OUT NOCOPY DATE
73 ,p_update_warning OUT NOCOPY BOOLEAN);
74
75 /* Added new parameters for update_etp_element_entry for Bug#2819479 */
76 PROCEDURE update_etp_element_entry(p_dt_update_mode IN VARCHAR2
77 ,p_session_date IN DATE
78 ,p_business_group_id IN NUMBER
79 ,p_element_entry_id IN NUMBER
80 ,p_object_version_number IN OUT NOCOPY NUMBER
81 ,p_redundancy_input_value_id IN NUMBER
82 ,p_compensation_input_value_id IN NUMBER /*14358180*/
83 ,p_pay_etp_input_value_id IN NUMBER
84 ,p_golden_input_value_id IN NUMBER
85 ,p_lieu_input_value_id IN NUMBER
86 ,p_sick_input_value_id IN NUMBER
87 ,p_rdo_input_value_id IN NUMBER
88 ,p_other_input_value_id IN NUMBER
89 ,p_pre_1983_input_value_id IN NUMBER
90 ,p_post_1983_input_value_id IN NUMBER
91 ,p_etp_cs_date_input_value_id IN NUMBER
92 ,p_trans_etp_input_value_id IN NUMBER /*5956223*/
93 ,p_part_prev_etp_input_value_id IN NUMBER /*5956223*/
94 ,p_redundancy_entry_value IN VARCHAR2
95 ,p_compensation_entry_value IN VARCHAR2 /*14358180*/
96 ,p_pay_etp_entry_value IN VARCHAR2
97 ,p_golden_entry_value IN VARCHAR2
98 ,p_lieu_entry_value IN VARCHAR2
99 ,p_sick_entry_value IN VARCHAR2
100 ,p_rdo_entry_value IN VARCHAR2
101 ,p_other_entry_value IN VARCHAR2
102 ,p_pre_1983_entry_value IN VARCHAR2
103 ,p_post_1983_entry_value IN VARCHAR2
104 ,p_etp_cs_date_entry_value IN VARCHAR2
105 ,p_trans_etp_entry_value IN VARCHAR2 /*5956223 */
106 ,p_part_of_prev_etp_entry_value IN VARCHAR2 /*5956223*/
107 ,p_redeundancy_ne_chk IN VARCHAR2 /*start 14358180*/
108 ,p_compensation_ne_chk IN VARCHAR2
109 ,p_golden_ne_chk IN VARCHAR2
110 ,p_lieu_ne_chk IN VARCHAR2
111 ,p_sick_ne_chk IN VARCHAR2
112 ,p_rdo_ne_chk IN VARCHAR2
113 ,p_other_ne_chk IN VARCHAR2 /*end 14358180*/
114 ,p_effective_start_date IN OUT NOCOPY DATE
115 ,p_effective_end_date IN OUT NOCOPY DATE
116 ,p_update_warning OUT NOCOPY BOOLEAN);
117
118 /* Bug 8769345 - Added new parameters to procedure in order to provide support for
119 two new input values added in Super Rollover element */
120 PROCEDURE update_super_element_entry
121 (p_dt_update_mode IN VARCHAR2
122 ,p_session_date IN DATE
123 ,p_business_group_id IN NUMBER
124 ,p_element_entry_id IN NUMBER
125 ,p_object_version_number IN OUT NOCOPY NUMBER
126 ,p_amount_input_value_id IN NUMBER
127 ,p_amount_entry_value IN VARCHAR2
128 ,p_amount_ppetp_input_value_id IN NUMBER
129 ,p_amount_ppetp_entry_value IN VARCHAR2
130 ,p_amount_nppetp_input_value_id IN NUMBER
131 ,p_amount_nppetp_entry_value IN VARCHAR2
132 ,p_tax_free_ppetp_ip_value_id IN NUMBER /* Start 8769345 */
133 ,p_tax_free_ppetp_entry_value IN VARCHAR2
134 ,p_tax_free_nppetp_ip_value_id IN NUMBER
135 ,p_tax_free_nppetp_entry_value IN VARCHAR2 /* End 8769345 */
136 ,p_personal_payment_method_id IN NUMBER
137 ,p_effective_start_date IN OUT NOCOPY DATE
138 ,p_effective_end_date IN OUT NOCOPY DATE
139 ,p_update_warning OUT NOCOPY BOOLEAN);
140
141
142 PROCEDURE update_foreign_element_entry
143 (p_dt_update_mode IN VARCHAR2
144 ,p_session_date IN DATE
145 ,p_business_group_id IN NUMBER
146 ,p_element_entry_id IN NUMBER
147 ,p_object_version_number IN OUT NOCOPY NUMBER
148 ,p_for_ratio_ovr_value IN VARCHAR2
149 ,p_for_ratio_ovr_input_value_id IN NUMBER
150 ,p_std_ratio_ovr_value IN VARCHAR2
151 ,p_std_ratio_ovr_input_value_id IN NUMBER
152 ,p_effective_start_date IN OUT NOCOPY DATE
153 ,p_effective_end_date IN OUT NOCOPY DATE
154 ,p_update_warning OUT NOCOPY BOOLEAN);
155
156
157 END pay_au_terminations_entry_api;