eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ASSOC_BAL dependencies on PAY_ASSOC_BAL

Line 1: package body pay_assoc_bal as

1: package body pay_assoc_bal as
2: /* $Header: pyascbal.pkb 120.0 2005/05/29 03:00:41 appldev noship $ */
3: --
4: /*
5: --

Line 204: hr_utility.set_location('pay_assoc_bal.assoc_bal',1);

200: v_ddf_column VARCHAR2(20);
201:
202: BEGIN
203:
204: hr_utility.set_location('pay_assoc_bal.assoc_bal',1);
205: hr_utility.set_location('Element : '||p_element_name,3);
206: hr_utility.set_location('Primary Balance : '||p_balance_name,5);
207: begin
208: SELECT element_type_id

Line 215: hr_utility.set_location('pay_assoc_bal.assoc_bal',7);

211: WHERE UPPER(element_name) = UPPER(p_element_name)
212: AND business_group_id IS NULL
213: AND legislation_code = 'US';
214:
215: hr_utility.set_location('pay_assoc_bal.assoc_bal',7);
216: SELECT balance_type_id
217: INTO v_baltype_id
218: FROM pay_balance_types
219: WHERE UPPER(balance_name) = UPPER(p_balance_name)

Line 231: hr_utility.set_location('pay_assoc_bal.assoc_bal',9);

227: end;
228:
229: IF UPPER(p_association) = 'PRIMARY BALANCE' THEN
230:
231: hr_utility.set_location('pay_assoc_bal.assoc_bal',9);
232: update pay_element_types_f
233: set ELEMENT_INFORMATION10 = v_baltype_id
234: where element_type_id = v_eletype_id
235: and business_group_id is null

Line 240: hr_utility.set_location('pay_assoc_bal.assoc_bal',11);

236: and legislation_code = 'US';
237:
238: ELSIF UPPER(p_association) IN ('ACCRUED BALANCE', 'GROSS BALANCE') THEN
239:
240: hr_utility.set_location('pay_assoc_bal.assoc_bal',11);
241: update pay_element_types_f
242: set ELEMENT_INFORMATION11 = v_baltype_id
243: where element_type_id = v_eletype_id
244: and business_group_id is null

Line 249: hr_utility.set_location('pay_assoc_bal.assoc_bal',13);

245: and legislation_code = 'US';
246:
247: ELSIF UPPER(p_association) IN ('ARREARS BALANCE', 'SUBJECT BALANCE', 'HOURS BALANCE') THEN
248:
249: hr_utility.set_location('pay_assoc_bal.assoc_bal',13);
250: update pay_element_types_f
251: set ELEMENT_INFORMATION12 = v_baltype_id
252: where element_type_id = v_eletype_id
253: and business_group_id is null

Line 258: hr_utility.set_location('pay_assoc_bal.assoc_bal',15);

254: and legislation_code = 'US';
255: --
256: ELSIF UPPER(p_association) IN ('NOT TAKEN BALANCE', 'PRETAX BALANCE') THEN
257: --
258: hr_utility.set_location('pay_assoc_bal.assoc_bal',15);
259: update pay_element_types_f
260: set ELEMENT_INFORMATION13 = v_baltype_id
261: where element_type_id = v_eletype_id
262: and business_group_id is null

Line 267: hr_utility.set_location('pay_assoc_bal.assoc_bal',17);

263: and legislation_code = 'US';
264: --
265: ELSIF UPPER(p_association) IN ('TOWARD BOND PURCHASE', 'SUBJECT WHABLE') THEN
266: --
267: hr_utility.set_location('pay_assoc_bal.assoc_bal',17);
268: update pay_element_types_f
269: set ELEMENT_INFORMATION14 = v_baltype_id
270: where element_type_id = v_eletype_id
271: and business_group_id is null

Line 276: hr_utility.set_location('pay_assoc_bal.assoc_bal',19);

272: and legislation_code = 'US';
273: --
274: ELSIF UPPER(p_association) IN ('ABLE BALANCE', 'SUBJECT NOT WHABLE') THEN
275: --
276: hr_utility.set_location('pay_assoc_bal.assoc_bal',19);
277: update pay_element_types_f
278: set ELEMENT_INFORMATION15 = v_baltype_id
279: where element_type_id = v_eletype_id
280: and business_group_id is null

Line 285: hr_utility.set_location('pay_assoc_bal.assoc_bal',21);

281: and legislation_code = 'US';
282: --
283: ELSIF UPPER(p_association) = 'EXCESS BALANCE' THEN
284: --
285: hr_utility.set_location('pay_assoc_bal.assoc_bal',21);
286: update pay_element_types_f
287: set ELEMENT_INFORMATION16 = v_baltype_id
288: where element_type_id = v_eletype_id
289: and business_group_id is null

Line 294: hr_utility.set_location('pay_assoc_bal.assoc_bal',23);

290: and legislation_code = 'US';
291: --
292: ELSIF UPPER(p_association) = 'TAXABLE BALANCE' THEN
293: --
294: hr_utility.set_location('pay_assoc_bal.assoc_bal',23);
295: update pay_element_types_f
296: set ELEMENT_INFORMATION17 = v_baltype_id
297: where element_type_id = v_eletype_id
298: and business_group_id is null

Line 303: hr_utility.set_location('pay_assoc_bal.assoc_bal',25);

299: and legislation_code = 'US';
300: --
301: ELSIF UPPER(p_association) = 'EXEMPT BALANCE' THEN
302: --
303: hr_utility.set_location('pay_assoc_bal.assoc_bal',25);
304: update pay_element_types_f
305: set ELEMENT_INFORMATION18 = v_baltype_id
306: where element_type_id = v_eletype_id
307: and business_group_id is null

Line 312: hr_utility.set_location('pay_assoc_bal.assoc_bal',27);

308: and legislation_code = 'US';
309: --
310: ELSIF UPPER(p_association) = 'EE OR ER CONTR BALANCE' THEN
311: --
312: hr_utility.set_location('pay_assoc_bal.assoc_bal',27);
313: update pay_element_types_f
314: set ELEMENT_INFORMATION19 = v_baltype_id
315: where element_type_id = v_eletype_id
316: and business_group_id is null

Line 321: hr_utility.set_location('pay_assoc_bal.assoc_bal',29);

317: and legislation_code = 'US';
318: --
319: ELSIF UPPER(p_association) = 'WITHHELD BALANCE' THEN
320: --
321: hr_utility.set_location('pay_assoc_bal.assoc_bal',29);
322: update pay_element_types_f
323: set ELEMENT_INFORMATION20 = v_baltype_id
324: where element_type_id = v_eletype_id
325: and business_group_id is null

Line 1058: END pay_assoc_bal;

1054: );
1055: --
1056: end create_associated_balances;
1057:
1058: END pay_assoc_bal;