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.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.6.12020000.3 2012/12/07 11:05:14 pparate ship $ */
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 130: -- hr_balance_feeds.lock_balance_type --

126: ============================================================================*/
127: --
128: ------------------------------------------------------------------------------
129: -- NAME --
130: -- hr_balance_feeds.lock_balance_type --
131: -- --
132: -- DESCRIPTION --
133: -- Takes a row level lock out on a specified balance type. --
134: ------------------------------------------------------------------------------

Line 164: 'hr_balance_feeds.lock_balance_type');

160: if csr_lock_balance%notfound then
161: close csr_lock_balance;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE',
164: 'hr_balance_feeds.lock_balance_type');
165: hr_utility.set_message_token('STEP','1');
166: hr_utility.raise_error;
167: else
168: close csr_lock_balance;

Line 175: -- hr_balance_feeds.bal_classifications_exist --

171: end lock_balance_type;
172: --
173: ------------------------------------------------------------------------------
174: -- NAME --
175: -- hr_balance_feeds.bal_classifications_exist --
176: -- --
177: -- DESCRIPTION --
178: -- Returns TRUE if a balance classification exists. --
179: ------------------------------------------------------------------------------

Line 209: -- hr_balance_feeds.manual_bal_feeds_exist --

205: end bal_classifications_exist;
206: --
207: ------------------------------------------------------------------------------
208: -- NAME --
209: -- hr_balance_feeds.manual_bal_feeds_exist --
210: -- --
211: -- DESCRIPTION --
212: -- Returns TRUE if a manual balance feed exists. --
213: -- A balance type has a manual balance feed if it has balance feeds whose --

Line 257: -- hr_balance_feeds.pay_value_name --

253: end manual_bal_feeds_exist;
254: --
255: ------------------------------------------------------------------------------
256: -- NAME --
257: -- hr_balance_feeds.pay_value_name --
258: -- --
259: -- DESCRIPTION --
260: -- Returns the translated name for the 'Pay Value'. --
261: ------------------------------------------------------------------------------

Line 279: 'hr_balance_feeds.pay_value_name');

275: exception
276: when no_data_found then
277: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
278: hr_utility.set_message_token('PROCEDURE',
279: 'hr_balance_feeds.pay_value_name');
280: hr_utility.set_message_token('STEP','1');
281: hr_utility.raise_error;
282: end;
283: --

Line 290: -- hr_balance_feeds.is_pay_value --

286: end pay_value_name;
287: --
288: ------------------------------------------------------------------------------
289: -- NAME --
290: -- hr_balance_feeds.is_pay_value --
291: -- --
292: -- DESCRIPTION --
293: -- Returns TRUE if input value is a Pay Value. --
294: ------------------------------------------------------------------------------

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

313: --
314: begin
315: --
316: -- Get translated name for pay value
317: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
318: -- Bug 2767760 - search for this bug number for full explanation of these
319: -- changes.
320: -- Set variable to base table pay value input value name
321: v_pay_value_name := 'Pay Value';

Line 339: -- hr_balance_feeds.is_primary_class --

335: end is_pay_value;
336: --
337: ------------------------------------------------------------------------------
338: -- NAME --
339: -- hr_balance_feeds.is_primary_class --
340: -- --
341: -- DESCRIPTION --
342: -- Returns if the classification is primary / sub classification. --
343: ------------------------------------------------------------------------------

Line 364: 'hr_balance_feeds.is_primary_class');

360: exception
361: when no_data_found then
362: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
363: hr_utility.set_message_token('PROCEDURE',
364: 'hr_balance_feeds.is_primary_class');
365: hr_utility.set_message_token('STEP','1');
366: hr_utility.raise_error;
367: end;
368: --

Line 379: -- hr_balance_feeds.bal_feed_end_date --

375: end is_primary_class;
376: --
377: ------------------------------------------------------------------------------
378: -- NAME --
379: -- hr_balance_feeds.bal_feed_end_date --
380: -- --
381: -- DESCRIPTION --
382: -- Returns the correct end date for a balance feed. It takes into account --
383: -- the end date of the input value and also any future balance feeds. --

Line 403: if hr_balance_feeds.bal_classifications_exist(p_balance_type_id) then

399: begin
400: --
401: -- Make sure that no balance classifications exist when creating a manual
402: -- balance feed
403: if hr_balance_feeds.bal_classifications_exist(p_balance_type_id) then
404: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
405: hr_utility.set_message_token('PROCEDURE',
406: 'hr_balance_feeds.bal_feed_end_date');
407: hr_utility.set_message_token('STEP','1');

Line 406: 'hr_balance_feeds.bal_feed_end_date');

402: -- balance feed
403: if hr_balance_feeds.bal_classifications_exist(p_balance_type_id) then
404: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
405: hr_utility.set_message_token('PROCEDURE',
406: 'hr_balance_feeds.bal_feed_end_date');
407: hr_utility.set_message_token('STEP','1');
408: hr_utility.raise_error;
409: end if;
410: --

Line 437: 'hr_balance_feeds.bal_feed_end_date');

433: exception
434: when no_data_found then
435: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
436: hr_utility.set_message_token('PROCEDURE',
437: 'hr_balance_feeds.bal_feed_end_date');
438: hr_utility.set_message_token('STEP','2');
439: hr_utility.raise_error;
440: end;
441: v_bal_feed_end_date := v_max_inp_val_end_date;

Line 468: -- hr_balance_feeds.ins_bal_feed --

464: end bal_feed_end_date;
465: --
466: ------------------------------------------------------------------------------
467: -- NAME --
468: -- hr_balance_feeds.ins_bal_feed --
469: -- --
470: -- DESCRIPTION --
471: -- Creates a balance feed.
472: -- Parameter p_mode added so the procedure can be called from the form or --

Line 543: 'hr_balance_feeds.ins_bal_feed');

539: if sql%rowcount = 0 then
540: if p_mode = 'FORM' then
541: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
542: hr_utility.set_message_token('PROCEDURE',
543: 'hr_balance_feeds.ins_bal_feed');
544: hr_utility.set_message_token('STEP','1');
545: hr_utility.raise_error;
546: elsif p_mode = 'STARTUP' then
547: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);

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

543: 'hr_balance_feeds.ins_bal_feed');
544: hr_utility.set_message_token('STEP','1');
545: hr_utility.raise_error;
546: elsif p_mode = 'STARTUP' then
547: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);
548: else -- p_mode is something other than FORM or Startup - error
549: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 20);
550: end if;
551: end if;

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

545: hr_utility.raise_error;
546: elsif p_mode = 'STARTUP' then
547: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 10);
548: else -- p_mode is something other than FORM or Startup - error
549: hr_utility.set_location('hr_balance_feeds.ins_bal_feed', 20);
550: end if;
551: end if;
552: --
553: end ins_bal_feed;

Line 557: -- hr_balance_feeds.ins_bf_bal_class --

553: end ins_bal_feed;
554: --
555: ------------------------------------------------------------------------------
556: -- NAME --
557: -- hr_balance_feeds.ins_bf_bal_class --
558: -- --
559: -- DESCRIPTION --
560: -- Creates balance feeds when a balance classification has been added. --
561: ------------------------------------------------------------------------------

Line 714: hr_balance_feeds.lock_balance_type

710: --
711: begin
712: --
713: -- Lock balance type to ensure balance feeds are consistent.
714: hr_balance_feeds.lock_balance_type
715: (p_balance_type_id);
716: --
717: -- Make sure that no manual balance feeds exist when creating a balance
718: -- classification.

Line 719: if hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) then

715: (p_balance_type_id);
716: --
717: -- Make sure that no manual balance feeds exist when creating a balance
718: -- classification.
719: if hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) then
720: --
721: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
722: hr_utility.set_message_token('PROCEDURE',
723: 'hr_balance_feeds.ins_bf_bal_class');

Line 723: 'hr_balance_feeds.ins_bf_bal_class');

719: if hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) then
720: --
721: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
722: hr_utility.set_message_token('PROCEDURE',
723: 'hr_balance_feeds.ins_bf_bal_class');
724: hr_utility.set_message_token('STEP','1');
725: hr_utility.raise_error;
726: --
727: end if;

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

726: --
727: end if;
728: --
729: -- Get translated name for the pay value.
730: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
731: --
732: -- Bug 2767760 - search for this bug number for full explanation of these
733: -- changes.
734: -- Set variable to base table pay value input value name

Line 745: hr_balance_feeds.ins_bal_feed

741: hr_utility.trace('bt: '||v_iv_rec.balance_name);
742: hr_utility.trace('clas: '||v_iv_rec.classification_name);
743: hr_utility.trace('et: '||v_iv_rec.element_name);
744: -- Create balance feed.
745: hr_balance_feeds.ins_bal_feed
746: (v_iv_rec.effective_start_date,
747: v_iv_rec.effective_end_date,
748: v_iv_rec.business_group_id,
749: v_iv_rec.legislation_code,

Line 762: -- hr_balance_feeds.upd_del_bf_bal_class --

758: end ins_bf_bal_class;
759: --
760: ------------------------------------------------------------------------------
761: -- NAME --
762: -- hr_balance_feeds.upd_del_bf_bal_class --
763: -- --
764: -- DESCRIPTION --
765: -- When updating or deleting a balance classification cascade to linked --
766: -- balance feeds NB. the parameter p_mode is used to specify which ie. --

Line 831: 'hr_balance_feeds.upd_del_bf_bal_class');

827: else
828: --
829: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
830: hr_utility.set_message_token('PROCEDURE',
831: 'hr_balance_feeds.upd_del_bf_bal_class');
832: hr_utility.set_message_token('STEP','1');
833: hr_utility.raise_error;
834: --
835: end if;

Line 843: -- hr_balance_feeds.ins_bf_pay_value --

839: end upd_del_bf_bal_class;
840: --
841: ------------------------------------------------------------------------------
842: -- NAME --
843: -- hr_balance_feeds.ins_bf_pay_value --
844: -- --
845: -- DESCRIPTION --
846: -- Creates balance feeds when a pay value is created. --
847: ------------------------------------------------------------------------------

Line 983: hr_balance_feeds.ins_bal_feed

979: for v_bt_rec in csr_bal_types_prim_class
980: (p_input_value_id) loop
981: --
982: -- Create balance feed.
983: hr_balance_feeds.ins_bal_feed
984: (v_bt_rec.effective_start_date,
985: v_bt_rec.effective_end_date,
986: v_bt_rec.business_group_id,
987: v_bt_rec.legislation_code,

Line 1002: hr_balance_feeds.ins_bal_feed

998: for v_bt_rec in csr_bal_types_sub_class
999: (p_input_value_id) loop
1000: --
1001: -- Create balance feed.
1002: hr_balance_feeds.ins_bal_feed
1003: (v_bt_rec.effective_start_date,
1004: v_bt_rec.effective_end_date,
1005: v_bt_rec.business_group_id,
1006: v_bt_rec.legislation_code,

Line 1019: -- hr_balance_feeds.ins_bf_sub_class_rule --

1015: end ins_bf_pay_value;
1016: --
1017: ------------------------------------------------------------------------------
1018: -- NAME --
1019: -- hr_balance_feeds.ins_bf_sub_class_rule --
1020: -- --
1021: -- DESCRIPTION --
1022: -- Creates automatic balance feeds when a sub classification rule is added. --
1023: ------------------------------------------------------------------------------

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

1101: --
1102: begin
1103: --
1104: -- Get translated name for the pay value.
1105: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
1106: --
1107: -- Bug 2767760 - variable is set to the base table value for iv name. We must
1108: -- use base table values rather than translation table names, because if an
1109: -- input_value is created in a French instance, the translated name for all

Line 1128: hr_balance_feeds.ins_bal_feed

1124: (p_sub_classification_rule_id,
1125: v_pay_value_name) loop
1126: --
1127: -- Create balance feed.
1128: hr_balance_feeds.ins_bal_feed
1129: (v_bt_rec.effective_start_date,
1130: v_bt_rec.effective_end_date,
1131: v_bt_rec.business_group_id,
1132: v_bt_rec.legislation_code,

Line 1145: -- hr_balance_feeds.del_bf_input_value --

1141: end ins_bf_sub_class_rule;
1142: --
1143: ------------------------------------------------------------------------------
1144: -- NAME --
1145: -- hr_balance_feeds.del_bf_input_value --
1146: -- --
1147: -- DESCRIPTION --
1148: -- Adjusts or removes balance feeds when an input value is deleted NB. --
1149: -- when shortening an input value all related balance feeds are shortened. --

Line 1277: if hr_balance_feeds.is_pay_value(p_input_value_id) then

1273: --
1274: -- See if input value being extended is the Pay Value NB. automatic
1275: -- balance feeds are only created for the Pay Value. Extend the balance
1276: -- feed to the new end date of the input value.
1277: if hr_balance_feeds.is_pay_value(p_input_value_id) then
1278: --
1279: for v_bf_rec in csr_bal_feeds_extend
1280: (p_input_value_id) loop
1281: --

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

1293: hr_utility.set_message(801,'HR_72033_CANNOT_DNC_RECORD');
1294: hr_utility.raise_error;
1295: else
1296: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1297: hr_utility.set_message_token('PROCEDURE','hr_balance_feeds.del_bf_input_value');
1298: hr_utility.set_message_token('STEP','1');
1299: hr_utility.raise_error;
1300: end if;
1301: --

Line 1308: -- hr_balance_feeds.del_bf_sub_class_rule --

1304: end del_bf_input_value;
1305: --
1306: ------------------------------------------------------------------------------
1307: -- NAME --
1308: -- hr_balance_feeds.del_bf_sub_class_rule --
1309: -- --
1310: -- DESCRIPTION --
1311: -- Adjusts or removes balance feeds when a sub classification rule is --
1312: -- deleted NB. this only affects automatic balance feeds. --

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

1352: --
1353: begin
1354: --
1355: -- Get translated name for pay value
1356: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
1357: --
1358: -- Bug 2767760 - search for this bug number for full explanation of these
1359: -- changes.
1360: -- Set variable to base table pay value input value name

Line 1412: 'hr_balance_feeds.del_bf_sub_class_rule');

1408: else
1409: --
1410: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1411: hr_utility.set_message_token('PROCEDURE',
1412: 'hr_balance_feeds.del_bf_sub_class_rule');
1413: hr_utility.set_message_token('STEP','1');
1414: hr_utility.raise_error;
1415: --
1416: end if;

Line 1422: -- hr_balance_feeds.bf_chk_proc_run_results --

1418: end del_bf_sub_class_rule;
1419: --
1420: ------------------------------------------------------------------------------
1421: -- NAME --
1422: -- hr_balance_feeds.bf_chk_proc_run_results --
1423: -- --
1424: -- DESCRIPTION --
1425: -- Detects if a change in a balance feed could result in a change of a --
1426: -- balance value ie. the period over which the balance feed changes --

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

1782: when others then
1783: v_check_value := 'Y';
1784: end;
1785: -- Get translated name for pay value
1786: -- v_pay_value_name := hr_balance_feeds.pay_value_name;
1787: -- Bug 2767760 - search for this bug number for full explanation of these
1788: -- changes.
1789: -- Set variable to base table pay value input value name
1790: v_pay_value_name := 'Pay Value';

Line 1990: 'hr_balance_feeds.bf_chk_proc_run_results');

1986: else
1987: --
1988: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1989: hr_utility.set_message_token('PROCEDURE',
1990: 'hr_balance_feeds.bf_chk_proc_run_results');
1991: hr_utility.set_message_token('STEP','1');
1992: hr_utility.raise_error;
1993: --
1994: end if;

Line 1998: end HR_BALANCE_FEEDS;

1994: end if;
1995: --
1996: end bf_chk_proc_run_results;
1997: --
1998: end HR_BALANCE_FEEDS;