[Home] [Help]
PACKAGE: APPS.PAY_BALANCE_TYPES_PKG
Source
1 PACKAGE PAY_BALANCE_TYPES_PKG as
2 /* $Header: pyblt01t.pkh 120.0 2005/05/29 03:20:26 appldev noship $ */
3 --------------------------------------------------------------------------------
4 procedure validate_translation (balance_type_id IN number,
5 language IN varchar2,
6 balance_name IN varchar2,
7 reporting_name IN varchar2);
8 --------------------------------------------------------------------------------
9 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
10 p_legislation_code IN VARCHAR2);
11 -----------------------------------------------------------------------------
12 -- Name
13 -- chk_balance_category_rule
14 --
15 -- Purpose
16 -- Checks whether column balance_category_id is mandatory for the current
17 -- legislation. It will only be mandatory when the legislation delivers
18 -- the legislation rule row and an upgrade script for populating all balances
19 -- with a balance category.
20 -----------------------------------------------------------------------------
21 function chk_balance_category_rule
22 (p_legislation_code varchar2
23 ,p_business_group_id number default null
24 )
25 return boolean;
26 -----------------------------------------------------------------------------
27 -- Name --
28 -- chk_balance_type --
29 -- Purpose --
30 -- Validates the balance type ie. unique name, only one remuneration --
31 -- balance etc ... --
32 -- Arguments --
33 -- See below. --
34 -- Notes --
35 -- --
36 -----------------------------------------------------------------------------
37 --
38 procedure chk_balance_type
39 (
40 p_row_id varchar2,
41 p_business_group_id number,
42 p_legislation_code varchar2,
43 p_balance_name varchar2,
44 p_reporting_name varchar2,
45 p_assignment_remuneration_flag varchar2
46 );
47 --
48 -----------------------------------------------------------------------------
49 -- Name --
50 -- Insert_Row --
51 -- Purpose --
52 -- Table handler procedure that supports the insert of a balance via the --
53 -- Define Balance Type form. --
54 -- Arguments --
55 -- See below. --
56 -- Notes --
57 -- --
58 -----------------------------------------------------------------------------
59 --
60 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
61 X_Balance_Type_Id IN OUT NOCOPY NUMBER,
62 X_Business_Group_Id NUMBER,
63 X_Legislation_Code VARCHAR2,
64 X_Currency_Code VARCHAR2,
65 X_Assignment_Remuneration_Flag VARCHAR2,
66 X_Balance_Name VARCHAR2,
67 -- --
68 X_Base_Balance_Name VARCHAR2,
69 -- --
70 X_Balance_Uom VARCHAR2,
71 X_Comments VARCHAR2,
72 X_Legislation_Subgroup VARCHAR2,
73 X_Reporting_Name VARCHAR2,
74 X_Attribute_Category VARCHAR2,
75 X_Attribute1 VARCHAR2,
76 X_Attribute2 VARCHAR2,
77 X_Attribute3 VARCHAR2,
78 X_Attribute4 VARCHAR2,
79 X_Attribute5 VARCHAR2,
80 X_Attribute6 VARCHAR2,
81 X_Attribute7 VARCHAR2,
82 X_Attribute8 VARCHAR2,
83 X_Attribute9 VARCHAR2,
84 X_Attribute10 VARCHAR2,
85 X_Attribute11 VARCHAR2,
86 X_Attribute12 VARCHAR2,
87 X_Attribute13 VARCHAR2,
88 X_Attribute14 VARCHAR2,
89 X_Attribute15 VARCHAR2,
90 X_Attribute16 VARCHAR2,
91 X_Attribute17 VARCHAR2,
92 X_Attribute18 VARCHAR2,
93 X_Attribute19 VARCHAR2,
94 X_Attribute20 VARCHAR2,
95 x_balance_category_id number default null,
96 x_base_balance_type_id number default null,
97 x_input_value_id number default null);
98 --
99 -----------------------------------------------------------------------------
100 -- Name --
101 -- Lock_Row --
102 -- Purpose --
103 -- Table handler procedure that supports the insert , update and delete --
104 -- of a balance by applying a lock on a balance in the Define Balance --
105 -- Type form. --
106 -- Arguments --
107 -- See below. --
108 -- Notes --
109 -- None. --
110 -----------------------------------------------------------------------------
111 --
112 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
113 X_Balance_Type_Id NUMBER,
114 X_Business_Group_Id NUMBER,
115 X_Legislation_Code VARCHAR2,
116 X_Currency_Code VARCHAR2,
117 X_Assignment_Remuneration_Flag VARCHAR2,
118 --X_Balance_Name VARCHAR2,
119 -- --
120 X_Base_Balance_Name VARCHAR2,
121 -- --
122 X_Balance_Uom VARCHAR2,
123 X_Comments VARCHAR2,
124 X_Legislation_Subgroup VARCHAR2,
125 X_Reporting_Name VARCHAR2,
126 X_Attribute_Category VARCHAR2,
127 X_Attribute1 VARCHAR2,
128 X_Attribute2 VARCHAR2,
129 X_Attribute3 VARCHAR2,
130 X_Attribute4 VARCHAR2,
131 X_Attribute5 VARCHAR2,
132 X_Attribute6 VARCHAR2,
133 X_Attribute7 VARCHAR2,
134 X_Attribute8 VARCHAR2,
135 X_Attribute9 VARCHAR2,
136 X_Attribute10 VARCHAR2,
137 X_Attribute11 VARCHAR2,
138 X_Attribute12 VARCHAR2,
139 X_Attribute13 VARCHAR2,
140 X_Attribute14 VARCHAR2,
141 X_Attribute15 VARCHAR2,
142 X_Attribute16 VARCHAR2,
143 X_Attribute17 VARCHAR2,
144 X_Attribute18 VARCHAR2,
145 X_Attribute19 VARCHAR2,
146 X_Attribute20 VARCHAR2,
147 x_balance_category_id number default null,
148 x_base_balance_type_id number default null,
149 x_input_value_id number default null);
150 --
151 -----------------------------------------------------------------------------
152 -- Name --
153 -- Update_Row --
154 -- Purpose --
155 -- Table handler procedure that supports the update of a balance via the --
156 -- Define Balance Type form. --
157 -- Arguments --
158 -- See below. --
159 -- Notes --
160 -- None. --
161 -----------------------------------------------------------------------------
162 --
163 PROCEDURE Update_Row(X_Rowid VARCHAR2,
164 X_Balance_Type_Id NUMBER,
165 X_Business_Group_Id NUMBER,
166 X_Legislation_Code VARCHAR2,
167 X_Currency_Code VARCHAR2,
168 X_Assignment_Remuneration_Flag VARCHAR2,
169 X_Balance_Name VARCHAR2,
170 X_Base_Balance_Name VARCHAR2,
171 X_Balance_Uom VARCHAR2,
172 X_Comments VARCHAR2,
173 X_Legislation_Subgroup VARCHAR2,
174 X_Reporting_Name VARCHAR2,
175 X_Attribute_Category VARCHAR2,
176 X_Attribute1 VARCHAR2,
177 X_Attribute2 VARCHAR2,
178 X_Attribute3 VARCHAR2,
179 X_Attribute4 VARCHAR2,
180 X_Attribute5 VARCHAR2,
181 X_Attribute6 VARCHAR2,
182 X_Attribute7 VARCHAR2,
183 X_Attribute8 VARCHAR2,
184 X_Attribute9 VARCHAR2,
185 X_Attribute10 VARCHAR2,
186 X_Attribute11 VARCHAR2,
187 X_Attribute12 VARCHAR2,
188 X_Attribute13 VARCHAR2,
189 X_Attribute14 VARCHAR2,
190 X_Attribute15 VARCHAR2,
191 X_Attribute16 VARCHAR2,
192 X_Attribute17 VARCHAR2,
193 X_Attribute18 VARCHAR2,
194 X_Attribute19 VARCHAR2,
195 X_Attribute20 VARCHAR2,
196 x_balance_category_id number default null,
197 x_base_balance_type_id number default null,
198 x_input_value_id number default null);
199 --
200 -----------------------------------------------------------------------------
201 -- Name --
202 -- Delete_Row --
203 -- Purpose --
204 -- Table handler procedure that supports the delete of a balance via the --
205 -- Define Balance Type form. --
206 -- Arguments --
207 -- See below. --
208 -- Notes --
209 -- --
210 -----------------------------------------------------------------------------
211 --
212 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
213 -- Extra Columns
214 X_Balance_Type_Id NUMBER);
215 --
216 ------------------------------------------------------------------------------
217 -- Name --
218 -- BALANACE_TYPE_CASCADE_DELETE --
219 -- Purpose --
220 -- procedure that supports the cascade delete of a balance feed,
221 -- balance classifications and defined balances. --
222 -- Arguments --
223 -- See below. --
224 -- Notes --
225 -- --
226 -----------------------------------------------------------------------------
227 --
228 procedure balance_type_cascade_delete
229 (
230 p_balance_type_id number
231 );
232
233 --
234 -----------------------------------------------------------------------------
235 -- Name --
236 -- ADD_LANGUAGE --
237 -- Purpose --
238 -- Table handler procedure for release 11.5 MLS (Multi-Lingual Support) --
239 -- Arguments --
240 -- None. --
241 -- Notes --
242 -- None. --
243 -----------------------------------------------------------------------------
244 procedure ADD_LANGUAGE;
245 ------------------------------------------------------------------------------
246 procedure TRANSLATE_ROW (
247 X_B_BALANCE_NAME in VARCHAR2,
248 X_B_LEGISLATION_CODE in VARCHAR2,
249 X_BALANCE_NAME in VARCHAR2,
250 X_REPORTING_NAME in VARCHAR2,
251 X_OWNER in VARCHAR2
252 );
253 ------------------------------------------------------------------------------
254 END PAY_BALANCE_TYPES_PKG;