[Home] [Help]
PACKAGE: APPS.FF_FORMULAS_F_PKG
Source
1 PACKAGE FF_FORMULAS_F_PKG as
2 /* $Header: fffra01t.pkh 120.1 2005/07/29 04:55:20 shisriva noship $ */
3
4
5 Type FormulaRec is Record ( formula_name ff_formulas_f.formula_name%type,
6 formula_type_id ff_formulas_f.formula_type_id%type,
7 business_group_id ff_formulas_f.business_group_id%type,
8 legislation_code ff_formulas_f.legislation_code%type,
9 effective_start_date date,
10 effective_end_date date);
11 -- ----------------------------------------------------------------------------
12 -- | Package Header Variable |
13 -- ----------------------------------------------------------------------------
14 --
15 g_dml_status boolean := FALSE; -- Global package variable
16
17 -----------------------------------------------------------------------------
18 -- Name --
19 -- payroll_del_validation --
20 -- Purpose --
21 -- Provides referential integrity chacks for payroll tables using --
22 -- formula when a formula is deleted. --
23 -- Arguments --
24 -- See below. --
25 -- Notes --
26 -- None. --
27 -- History --
28 -- 13-Sep-04 --
29 -- Added parameter p_formula_details. Bug No 3703492. --
30 -----------------------------------------------------------------------------
31 --
32 procedure payroll_del_validation
33 (
34 p_formula_id number,
35 p_dt_delete_mode varchar2,
36 p_validation_start_date date,
37 p_validation_end_date date,
38 p_Formula_Details FormulaRec
39 );
40 --
41 -----------------------------------------------------------------------------
42 -- Name --
43 -- payroll_dnc_validation --
44 -- Purpose --
45 -- Provides check for conflicting records when selecting delete next --
46 -- change or future change operations.
47 -- Arguments --
48 -- See below. --
49 -- Notes --
50 -- None. --
51 -- History --
52 -- 13-Sep-04 --
53 -- Added parameter p_formula_details. Bug No 3703492. --
54 -----------------------------------------------------------------------------
55 --
56 procedure payroll_dnc_validation
57 (
58 p_formula_id number,
59 p_dt_delete_mode varchar2,
60 p_validation_start_date date,
61 p_validation_end_date date,
62 p_formula_details FormulaRec
63 );
64 --
65 -----------------------------------------------------------------------------
66 -- Name --
67 -- Insert_Row --
68 -- Purpose --
69 -- Table handler procedure that supports the insert of a formula via the --
70 -- Write Formula form. --
71 -- Arguments --
72 -- See below. --
73 -- Notes --
74 -- A check is made to ensure the formula name is unique. --
75 -----------------------------------------------------------------------------
76 --
77 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
78 X_Formula_Id IN OUT NOCOPY NUMBER,
79 X_Effective_Start_Date DATE,
80 X_Effective_End_Date DATE,
81 X_Business_Group_Id NUMBER,
82 X_Legislation_Code VARCHAR2,
83 X_Formula_Type_Id NUMBER,
84 X_Formula_Name IN OUT NOCOPY VARCHAR2,
85 X_Description VARCHAR2,
86 X_Formula_Text VARCHAR2,
87 X_Sticky_Flag VARCHAR2,
88 X_Last_Update_Date IN OUT NOCOPY DATE);
89 --
90 -----------------------------------------------------------------------------
91 -- Name --
92 -- Lock_Row (OVERLOADED) --
93 -- Purpose --
94 -- Table handler procedure that supports the insert , update and delete --
95 -- of a formula by applying a lock on a formula in the Write Formula --
96 -- form. --
97 -- Arguments --
98 -- See below. --
99 -- Notes --
100 -- This version checks each column to see if the formula has changed. --
101 -----------------------------------------------------------------------------
102 --
103 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
104 X_Formula_Id NUMBER,
105 X_Effective_Start_Date DATE,
106 X_Effective_End_Date DATE,
107 X_Business_Group_Id NUMBER,
108 X_Legislation_Code VARCHAR2,
109 X_Formula_Type_Id NUMBER,
110 X_Formula_Name VARCHAR2,
111 X_Description VARCHAR2,
112 X_Formula_Text VARCHAR2,
113 X_Sticky_Flag VARCHAR2,
114 X_Base_Formula_Name VARCHAR2 default NULL,
115 X_Base_Description VARCHAR2 default NULL);
116 --
117 -----------------------------------------------------------------------------
118 -- Name --
119 -- Lock_Row (OVERLOADED) --
120 -- Purpose --
121 -- Table handler procedure that supports the insert , update and delete --
122 -- of a formula by applying a lock on a formula in the Write Formula --
123 -- form. --
124 -- Arguments --
125 -- See below. --
126 -- Notes --
127 -- This version tests the last_update_date to see if the formula has --
128 -- changed. --
129 -----------------------------------------------------------------------------
130 --
131 PROCEDURE Lock_Row(x_rowid VARCHAR2,
132 x_last_update_date DATE);
133 --
134 -----------------------------------------------------------------------------
135 -- Name --
136 -- Update_Row --
137 -- Purpose --
138 -- Table handler procedure that supports the update of a formula via the --
139 -- Write Formula form. --
140 -- Arguments --
141 -- See below. --
142 -- Notes --
143 -- None. --
144 -----------------------------------------------------------------------------
145 --
146 PROCEDURE Update_Row(X_Rowid VARCHAR2,
147 X_Formula_Id NUMBER,
148 X_Effective_Start_Date DATE,
149 X_Effective_End_Date DATE,
150 X_Business_Group_Id NUMBER,
151 X_Legislation_Code VARCHAR2,
152 X_Formula_Type_Id NUMBER,
153 X_Formula_Name VARCHAR2,
154 X_Description VARCHAR2,
155 X_Formula_Text VARCHAR2,
156 X_Sticky_Flag VARCHAR2,
157 X_Last_Update_Date IN OUT NOCOPY DATE,
158 X_Base_Formula_Name VARCHAR2 default hr_api.g_varchar2,
159 X_Base_Description VARCHAR2 default hr_api.g_varchar2);
160 --
161 -----------------------------------------------------------------------------
162 -- Name --
163 -- Delete_Row --
164 -- Purpose --
165 -- Table handler procedure that supports the delete of a formula via the --
166 -- Write Formula form. --
167 -- Arguments --
168 -- See below. --
169 -- Notes --
170 -- Referential integrity checks are done against any payroll tables that --
171 -- make use of formula. --
172 -- History --
173 -- 13-Sep-04 --
174 -- Added parameter X_Effective_Date. Bug No 3703492. --
175 -- 16-Sep-04 --
176 -- Defaulted X_Effective_date to sysdate and changed the order of --
177 -- arguments. --
178 -----------------------------------------------------------------------------
179 --
180 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
181 -- Extra Columns
182 X_Formula_Id NUMBER,
183 X_Dt_Delete_Mode VARCHAR2,
184 X_Validation_Start_Date DATE,
185 X_Validation_End_Date DATE,
186 X_Effective_Date DATE default trunc(sysdate) );
187 --
188 ---For MLS----------------------------------------------------------------------
189 procedure ADD_LANGUAGE;
190
191 procedure TRANSLATE_ROW ( X_B_FORMULA_NAME VARCHAR2,
192 X_B_LEGISLATION_CODE VARCHAR2,
193 X_FORMULA_NAME VARCHAR2,
194 X_DESCRIPTION VARCHAR2,
195 X_OWNER VARCHAR2);
196
197 PROCEDURE set_translation_globals(p_business_group_id NUMBER,
198 p_legislation_code VARCHAR2);
199
200 procedure validate_translation(formula_id NUMBER,
201 language VARCHAR2,
202 formula_name VARCHAR2,
203 description VARCHAR2,
204 p_business_group_id IN NUMBER DEFAULT NULL,
205 p_legislation_code IN VARCHAR2 DEFAULT NULL);
206
207 function return_dml_status return boolean;
208 ---
209 END FF_FORMULAS_F_PKG;