1 PACKAGE pay_au_terminations_entry_api AS
2 /* $Header: pyautapi.pkh 120.4.12000000.4 2007/09/06 06:39:33 priupadh 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 */
30 ---------------------------------------------------------------------------------------
31
32 PROCEDURE update_al_element_entry(p_dt_update_mode IN VARCHAR2
33 ,p_session_date IN DATE
34 ,p_business_group_id IN NUMBER
35 ,p_element_entry_id IN NUMBER
36 ,p_object_version_number IN OUT NOCOPY NUMBER
37 ,p_hours_input_value_id IN NUMBER
38 ,p_payment_input_value_id IN NUMBER
39 ,p_loading_input_value_id IN NUMBER
40 ,p_other_input_value_id IN NUMBER
41 ,p_hours_entry_value IN VARCHAR2
42 ,p_payment_entry_value IN VARCHAR2
43 ,p_loading_entry_value IN VARCHAR2
44 ,p_other_entry_value IN VARCHAR2
45 ,p_effective_start_date IN OUT NOCOPY DATE
46 ,p_effective_end_date IN OUT NOCOPY DATE
47 ,p_update_warning OUT NOCOPY BOOLEAN) ;
48
49 PROCEDURE update_lsl_element_entry(p_dt_update_mode IN VARCHAR2
50 ,p_session_date IN DATE
51 ,p_business_group_id IN NUMBER
52 ,p_element_entry_id IN NUMBER
53 ,p_object_version_number IN OUT NOCOPY NUMBER
54 ,p_pre78_pay_input_value_id IN NUMBER
55 ,p_post78_pay_input_value_id IN NUMBER
56 ,p_post93_pay_input_value_id IN NUMBER
57 ,p_pre78_hours_input_value_id IN NUMBER
58 ,p_post78_hours_input_value_id IN NUMBER
59 ,p_post93_hours_input_value_id IN NUMBER
60 ,p_override_elig_input_value_id IN NUMBER /*Bug# 5056831 */
61 ,p_pre78_pay_entry_value IN VARCHAR2
62 ,p_post78_pay_entry_value IN VARCHAR2
63 ,p_post93_pay_entry_value IN VARCHAR2
64 ,p_pre78_hours_entry_value IN VARCHAR2
65 ,p_post78_hours_entry_value IN VARCHAR2
66 ,p_post93_hours_entry_value IN VARCHAR2
67 ,p_override_elig_entry_value IN VARCHAR2 /*Bug# 5056831 */
68 ,p_effective_start_date IN OUT NOCOPY DATE
69 ,p_effective_end_date IN OUT NOCOPY DATE
70 ,p_update_warning OUT NOCOPY BOOLEAN);
71
72 /* Added new parameters for update_etp_element_entry for Bug#2819479 */
73 PROCEDURE update_etp_element_entry(p_dt_update_mode IN VARCHAR2
74 ,p_session_date IN DATE
75 ,p_business_group_id IN NUMBER
76 ,p_element_entry_id IN NUMBER
77 ,p_object_version_number IN OUT NOCOPY NUMBER
78 ,p_redundancy_input_value_id IN NUMBER
79 ,p_pay_etp_input_value_id IN NUMBER
80 ,p_golden_input_value_id IN NUMBER
81 ,p_lieu_input_value_id IN NUMBER
82 ,p_sick_input_value_id IN NUMBER
83 ,p_rdo_input_value_id IN NUMBER
84 ,p_other_input_value_id IN NUMBER
85 ,p_pre_1983_input_value_id IN NUMBER
86 ,p_post_1983_input_value_id IN NUMBER
87 ,p_etp_cs_date_input_value_id IN NUMBER
88 ,p_trans_etp_input_value_id IN NUMBER /*5956223*/
89 ,p_part_prev_etp_input_value_id IN NUMBER /*5956223*/
90 ,p_redundancy_entry_value IN VARCHAR2
91 ,p_pay_etp_entry_value IN VARCHAR2
92 ,p_golden_entry_value IN VARCHAR2
93 ,p_lieu_entry_value IN VARCHAR2
94 ,p_sick_entry_value IN VARCHAR2
95 ,p_rdo_entry_value IN VARCHAR2
96 ,p_other_entry_value IN VARCHAR2
97 ,p_pre_1983_entry_value IN VARCHAR2
98 ,p_post_1983_entry_value IN VARCHAR2
99 ,p_etp_cs_date_entry_value IN VARCHAR2
100 ,p_trans_etp_entry_value IN VARCHAR2 /*5956223 */
101 ,p_part_of_prev_etp_entry_value IN VARCHAR2 /*5956223*/
102 ,p_effective_start_date IN OUT NOCOPY DATE
103 ,p_effective_end_date IN OUT NOCOPY DATE
104 ,p_update_warning OUT NOCOPY BOOLEAN);
105
106 PROCEDURE update_super_element_entry
107 (p_dt_update_mode IN VARCHAR2
108 ,p_session_date IN DATE
109 ,p_business_group_id IN NUMBER
110 ,p_element_entry_id IN NUMBER
111 ,p_object_version_number IN OUT NOCOPY NUMBER
112 ,p_amount_input_value_id IN NUMBER
113 ,p_amount_entry_value IN VARCHAR2
114 ,p_amount_ppetp_input_value_id IN NUMBER
115 ,p_amount_ppetp_entry_value IN VARCHAR2
116 ,p_amount_nppetp_input_value_id IN NUMBER
117 ,p_amount_nppetp_entry_value IN VARCHAR2
118 ,p_personal_payment_method_id IN NUMBER
119 ,p_effective_start_date IN OUT NOCOPY DATE
120 ,p_effective_end_date IN OUT NOCOPY DATE
121 ,p_update_warning OUT NOCOPY BOOLEAN);
122
123
124 END pay_au_terminations_entry_api;