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.

[Home] [Help]

APPS.HR_BALANCE_FEEDS dependencies on HR_BALANCE_FEEDS

Line 1: PACKAGE BODY HR_BALANCE_FEEDS as

1: PACKAGE BODY HR_BALANCE_FEEDS as
2: /* $Header: pybalfed.pkb 120.5 2006/08/10 13:33:59 alogue noship $ */
3: --
4: /*===========================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: hr_balance_feeds

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +============================================================================+
9: Name
10: hr_balance_feeds
11: Purpose
12:
13: This package supports the maintenance of balance feeds either by
14: generating them according to system events ie. adding a balance

Line 122: -- hr_balance_feeds.lock_balance_type --

118: ============================================================================*/
119: --
120: ------------------------------------------------------------------------------
121: -- NAME --
122: -- hr_balance_feeds.lock_balance_type --
123: -- --
124: -- DESCRIPTION --
125: -- Takes a row level lock out on a specified balance type. --
126: ------------------------------------------------------------------------------

Line 156: 'hr_balance_feeds.lock_balance_type');

152: if csr_lock_balance%notfound then
153: close csr_lock_balance;
154: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
155: hr_utility.set_message_token('PROCEDURE',
156: 'hr_balance_feeds.lock_balance_type');
157: hr_utility.set_message_token('STEP','1');
158: hr_utility.raise_error;
159: else
160: close csr_lock_balance;

Line 167: -- hr_balance_feeds.bal_classifications_exist --

163: end lock_balance_type;
164: --
165: ------------------------------------------------------------------------------
166: -- NAME --
167: -- hr_balance_feeds.bal_classifications_exist --
168: -- --
169: -- DESCRIPTION --
170: -- Returns TRUE if a balance classification exists. --
171: ------------------------------------------------------------------------------

Line 201: -- hr_balance_feeds.manual_bal_feeds_exist --

197: end bal_classifications_exist;
198: --
199: ------------------------------------------------------------------------------
200: -- NAME --
201: -- hr_balance_feeds.manual_bal_feeds_exist --
202: -- --
203: -- DESCRIPTION --
204: -- Returns TRUE if a manual balance feed exists. --
205: -- A balance type has a manual balance feed if it has balance feeds whose --

Line 249: -- hr_balance_feeds.pay_value_name --

245: end manual_bal_feeds_exist;
246: --
247: ------------------------------------------------------------------------------
248: -- NAME --
249: -- hr_balance_feeds.pay_value_name --
250: -- --
251: -- DESCRIPTION --
252: -- Returns the translated name for the 'Pay Value'. --
253: ------------------------------------------------------------------------------

Line 271: 'hr_balance_feeds.pay_value_name');

267: exception
268: when no_data_found then
269: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('PROCEDURE',
271: 'hr_balance_feeds.pay_value_name');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end;
275: --

Line 282: -- hr_balance_feeds.is_pay_value --

278: end pay_value_name;
279: --
280: ------------------------------------------------------------------------------
281: -- NAME --
282: -- hr_balance_feeds.is_pay_value --
283: -- --
284: -- DESCRIPTION --
285: -- Returns TRUE if input value is a Pay Value. --
286: ------------------------------------------------------------------------------

Line 309: -- v_pay_value_name := hr_balance_feeds.pay_value_name;

305: --
306: begin
307: --
308: -- Get translated name for pay value
309: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
310: -- Bug 2767760 - search for this bug number for full explanation of these
311: -- changes.
312: -- Set variable to base table pay value input value name
313: v_pay_value_name := 'Pay Value';

Line 331: -- hr_balance_feeds.is_primary_class --

327: end is_pay_value;
328: --
329: ------------------------------------------------------------------------------
330: -- NAME --
331: -- hr_balance_feeds.is_primary_class --
332: -- --
333: -- DESCRIPTION --
334: -- Returns if the classification is primary / sub classification. --
335: ------------------------------------------------------------------------------

Line 356: 'hr_balance_feeds.is_primary_class');

352: exception
353: when no_data_found then
354: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
355: hr_utility.set_message_token('PROCEDURE',
356: 'hr_balance_feeds.is_primary_class');
357: hr_utility.set_message_token('STEP','1');
358: hr_utility.raise_error;
359: end;
360: --

Line 371: -- hr_balance_feeds.bal_feed_end_date --

367: end is_primary_class;
368: --
369: ------------------------------------------------------------------------------
370: -- NAME --
371: -- hr_balance_feeds.bal_feed_end_date --
372: -- --
373: -- DESCRIPTION --
374: -- Returns the correct end date for a balance feed. It takes into account --
375: -- the end date of the input value and also any future balance feeds. --

Line 395: if hr_balance_feeds.bal_classifications_exist(p_balance_type_id) then

391: begin
392: --
393: -- Make sure that no balance classifications exist when creating a manual
394: -- balance feed
395: if hr_balance_feeds.bal_classifications_exist(p_balance_type_id) then
396: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
397: hr_utility.set_message_token('PROCEDURE',
398: 'hr_balance_feeds.bal_feed_end_date');
399: hr_utility.set_message_token('STEP','1');

Line 398: 'hr_balance_feeds.bal_feed_end_date');

394: -- balance feed
395: if hr_balance_feeds.bal_classifications_exist(p_balance_type_id) then
396: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
397: hr_utility.set_message_token('PROCEDURE',
398: 'hr_balance_feeds.bal_feed_end_date');
399: hr_utility.set_message_token('STEP','1');
400: hr_utility.raise_error;
401: end if;
402: --

Line 429: 'hr_balance_feeds.bal_feed_end_date');

425: exception
426: when no_data_found then
427: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
428: hr_utility.set_message_token('PROCEDURE',
429: 'hr_balance_feeds.bal_feed_end_date');
430: hr_utility.set_message_token('STEP','2');
431: hr_utility.raise_error;
432: end;
433: v_bal_feed_end_date := v_max_inp_val_end_date;

Line 460: -- hr_balance_feeds.ins_bal_feed --

456: end bal_feed_end_date;
457: --
458: ------------------------------------------------------------------------------
459: -- NAME --
460: -- hr_balance_feeds.ins_bal_feed --
461: -- --
462: -- DESCRIPTION --
463: -- Creates a balance feed.
464: -- Parameter p_mode added so the procedure can be called from the form or --

Line 533: 'hr_balance_feeds.ins_bal_feed');

529: if sql%rowcount = 0 then
530: if p_mode = 'FORM' then
531: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
532: hr_utility.set_message_token('PROCEDURE',
533: 'hr_balance_feeds.ins_bal_feed');
534: hr_utility.set_message_token('STEP','1');
535: hr_utility.raise_error;
536: elsif p_mode = 'STARTUP' then
537: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);

Line 537: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);

533: 'hr_balance_feeds.ins_bal_feed');
534: hr_utility.set_message_token('STEP','1');
535: hr_utility.raise_error;
536: elsif p_mode = 'STARTUP' then
537: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);
538: else -- p_mode is something other than FORM or Startup - error
539: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 20);
540: end if;
541: end if;

Line 539: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 20);

535: hr_utility.raise_error;
536: elsif p_mode = 'STARTUP' then
537: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);
538: else -- p_mode is something other than FORM or Startup - error
539: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 20);
540: end if;
541: end if;
542: --
543: end ins_bal_feed;

Line 547: -- hr_balance_feeds.ins_bf_bal_class --

543: end ins_bal_feed;
544: --
545: ------------------------------------------------------------------------------
546: -- NAME --
547: -- hr_balance_feeds.ins_bf_bal_class --
548: -- --
549: -- DESCRIPTION --
550: -- Creates balance feeds when a balance classification has been added. --
551: ------------------------------------------------------------------------------

Line 704: hr_balance_feeds.lock_balance_type

700: --
701: begin
702: --
703: -- Lock balance type to ensure balance feeds are consistent.
704: hr_balance_feeds.lock_balance_type
705: (p_balance_type_id);
706: --
707: -- Make sure that no manual balance feeds exist when creating a balance
708: -- classification.

Line 709: if hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) then

705: (p_balance_type_id);
706: --
707: -- Make sure that no manual balance feeds exist when creating a balance
708: -- classification.
709: if hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) then
710: --
711: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
712: hr_utility.set_message_token('PROCEDURE',
713: 'hr_balance_feeds.ins_bf_bal_class');

Line 713: 'hr_balance_feeds.ins_bf_bal_class');

709: if hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) then
710: --
711: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
712: hr_utility.set_message_token('PROCEDURE',
713: 'hr_balance_feeds.ins_bf_bal_class');
714: hr_utility.set_message_token('STEP','1');
715: hr_utility.raise_error;
716: --
717: end if;

Line 720: -- v_pay_value_name := hr_balance_feeds.pay_value_name;

716: --
717: end if;
718: --
719: -- Get translated name for the pay value.
720: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
721: --
722: -- Bug 2767760 - search for this bug number for full explanation of these
723: -- changes.
724: -- Set variable to base table pay value input value name

Line 735: hr_balance_feeds.ins_bal_feed

731: hr_utility.trace('bt: '||v_iv_rec.balance_name);
732: hr_utility.trace('clas: '||v_iv_rec.classification_name);
733: hr_utility.trace('et: '||v_iv_rec.element_name);
734: -- Create balance feed.
735: hr_balance_feeds.ins_bal_feed
736: (v_iv_rec.effective_start_date,
737: v_iv_rec.effective_end_date,
738: v_iv_rec.business_group_id,
739: v_iv_rec.legislation_code,

Line 752: -- hr_balance_feeds.upd_del_bf_bal_class --

748: end ins_bf_bal_class;
749: --
750: ------------------------------------------------------------------------------
751: -- NAME --
752: -- hr_balance_feeds.upd_del_bf_bal_class --
753: -- --
754: -- DESCRIPTION --
755: -- When updating or deleting a balance classification cascade to linked --
756: -- balance feeds NB. the parameter p_mode is used to specify which ie. --

Line 821: 'hr_balance_feeds.upd_del_bf_bal_class');

817: else
818: --
819: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
820: hr_utility.set_message_token('PROCEDURE',
821: 'hr_balance_feeds.upd_del_bf_bal_class');
822: hr_utility.set_message_token('STEP','1');
823: hr_utility.raise_error;
824: --
825: end if;

Line 833: -- hr_balance_feeds.ins_bf_pay_value --

829: end upd_del_bf_bal_class;
830: --
831: ------------------------------------------------------------------------------
832: -- NAME --
833: -- hr_balance_feeds.ins_bf_pay_value --
834: -- --
835: -- DESCRIPTION --
836: -- Creates balance feeds when a pay value is created. --
837: ------------------------------------------------------------------------------

Line 973: hr_balance_feeds.ins_bal_feed

969: for v_bt_rec in csr_bal_types_prim_class
970: (p_input_value_id) loop
971: --
972: -- Create balance feed.
973: hr_balance_feeds.ins_bal_feed
974: (v_bt_rec.effective_start_date,
975: v_bt_rec.effective_end_date,
976: v_bt_rec.business_group_id,
977: v_bt_rec.legislation_code,

Line 992: hr_balance_feeds.ins_bal_feed

988: for v_bt_rec in csr_bal_types_sub_class
989: (p_input_value_id) loop
990: --
991: -- Create balance feed.
992: hr_balance_feeds.ins_bal_feed
993: (v_bt_rec.effective_start_date,
994: v_bt_rec.effective_end_date,
995: v_bt_rec.business_group_id,
996: v_bt_rec.legislation_code,

Line 1009: -- hr_balance_feeds.ins_bf_sub_class_rule --

1005: end ins_bf_pay_value;
1006: --
1007: ------------------------------------------------------------------------------
1008: -- NAME --
1009: -- hr_balance_feeds.ins_bf_sub_class_rule --
1010: -- --
1011: -- DESCRIPTION --
1012: -- Creates automatic balance feeds when a sub classification rule is added. --
1013: ------------------------------------------------------------------------------

Line 1095: -- v_pay_value_name := hr_balance_feeds.pay_value_name;

1091: --
1092: begin
1093: --
1094: -- Get translated name for the pay value.
1095: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
1096: --
1097: -- Bug 2767760 - variable is set to the base table value for iv name. We must
1098: -- use base table values rather than translation table names, because if an
1099: -- input_value is created in a French instance, the translated name for all

Line 1118: hr_balance_feeds.ins_bal_feed

1114: (p_sub_classification_rule_id,
1115: v_pay_value_name) loop
1116: --
1117: -- Create balance feed.
1118: hr_balance_feeds.ins_bal_feed
1119: (v_bt_rec.effective_start_date,
1120: v_bt_rec.effective_end_date,
1121: v_bt_rec.business_group_id,
1122: v_bt_rec.legislation_code,

Line 1135: -- hr_balance_feeds.del_bf_input_value --

1131: end ins_bf_sub_class_rule;
1132: --
1133: ------------------------------------------------------------------------------
1134: -- NAME --
1135: -- hr_balance_feeds.del_bf_input_value --
1136: -- --
1137: -- DESCRIPTION --
1138: -- Adjusts or removes balance feeds when an input value is deleted NB. --
1139: -- when shortening an input value all related balance feeds are shortened. --

Line 1267: if hr_balance_feeds.is_pay_value(p_input_value_id) then

1263: --
1264: -- See if input value being extended is the Pay Value NB. automatic
1265: -- balance feeds are only created for the Pay Value. Extend the balance
1266: -- feed to the new end date of the input value.
1267: if hr_balance_feeds.is_pay_value(p_input_value_id) then
1268: --
1269: for v_bf_rec in csr_bal_feeds_extend
1270: (p_input_value_id) loop
1271: --

Line 1287: hr_utility.set_message_token('PROCEDURE','hr_balance_feeds.del_bf_input_value');

1283: hr_utility.set_message(801,'HR_72033_CANNOT_DNC_RECORD');
1284: hr_utility.raise_error;
1285: else
1286: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1287: hr_utility.set_message_token('PROCEDURE','hr_balance_feeds.del_bf_input_value');
1288: hr_utility.set_message_token('STEP','1');
1289: hr_utility.raise_error;
1290: end if;
1291: --

Line 1298: -- hr_balance_feeds.del_bf_sub_class_rule --

1294: end del_bf_input_value;
1295: --
1296: ------------------------------------------------------------------------------
1297: -- NAME --
1298: -- hr_balance_feeds.del_bf_sub_class_rule --
1299: -- --
1300: -- DESCRIPTION --
1301: -- Adjusts or removes balance feeds when a sub classification rule is --
1302: -- deleted NB. this only affects automatic balance feeds. --

Line 1346: -- v_pay_value_name := hr_balance_feeds.pay_value_name;

1342: --
1343: begin
1344: --
1345: -- Get translated name for pay value
1346: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
1347: --
1348: -- Bug 2767760 - search for this bug number for full explanation of these
1349: -- changes.
1350: -- Set variable to base table pay value input value name

Line 1402: 'hr_balance_feeds.del_bf_sub_class_rule');

1398: else
1399: --
1400: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1401: hr_utility.set_message_token('PROCEDURE',
1402: 'hr_balance_feeds.del_bf_sub_class_rule');
1403: hr_utility.set_message_token('STEP','1');
1404: hr_utility.raise_error;
1405: --
1406: end if;

Line 1412: -- hr_balance_feeds.bf_chk_proc_run_results --

1408: end del_bf_sub_class_rule;
1409: --
1410: ------------------------------------------------------------------------------
1411: -- NAME --
1412: -- hr_balance_feeds.bf_chk_proc_run_results --
1413: -- --
1414: -- DESCRIPTION --
1415: -- Detects if a change in a balance feed could result in a change of a --
1416: -- balance value ie. the period over which the balance feed changes --

Line 1765: -- v_pay_value_name := hr_balance_feeds.pay_value_name;

1761: --
1762: begin
1763: --
1764: -- Get translated name for pay value
1765: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
1766: -- Bug 2767760 - search for this bug number for full explanation of these
1767: -- changes.
1768: -- Set variable to base table pay value input value name
1769: v_pay_value_name := 'Pay Value';

Line 1945: 'hr_balance_feeds.bf_chk_proc_run_results');

1941: else
1942: --
1943: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1944: hr_utility.set_message_token('PROCEDURE',
1945: 'hr_balance_feeds.bf_chk_proc_run_results');
1946: hr_utility.set_message_token('STEP','1');
1947: hr_utility.raise_error;
1948: --
1949: end if;

Line 1953: end HR_BALANCE_FEEDS;

1949: end if;
1950: --
1951: end bf_chk_proc_run_results;
1952: --
1953: end HR_BALANCE_FEEDS;