APPS.PAY_BALANCE_FEEDS_F_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 1: PACKAGE BODY PAY_BALANCE_FEEDS_F_PKG as

1: PACKAGE BODY PAY_BALANCE_FEEDS_F_PKG as
2: /* $Header: pyblf01t.pkb 120.0 2005/05/29 03:19 appldev noship $ */
3: --
4: /*==========================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: pay_balance_feeds_f_pkg

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +===========================================================================+
9: Name
10: pay_balance_feeds_f_pkg
11: Purpose
12: Used by PAYWSDBT (Define Balance Type) for the balance feeds block (BLF).
13: Notes
14:

Line 85: CURSOR C IS SELECT rowid FROM pay_balance_feeds_f

81: X_Legislation_Subgroup VARCHAR2,
82: X_Initial_Balance_Feed BOOLEAN ) IS
83: --
84: l_balance_feed_id number:= X_Balance_Feed_Id;
85: CURSOR C IS SELECT rowid FROM pay_balance_feeds_f
86: WHERE balance_feed_id = l_balance_feed_id;
87: --
88: CURSOR C2 IS SELECT pay_balance_feeds_s.nextval FROM sys.dual;
89: --

Line 99: FROM pay_balance_feeds_f blf,

95: := nvl(X_Legislation_Code
96: ,hr_api.return_legislation_code(X_Business_Group_Id));
97: --
98: CURSOR C3 IS SELECT 'Y'
99: FROM pay_balance_feeds_f blf,
100: pay_input_values_f inv,
101: pay_element_types_f elt,
102: pay_element_classifications ec
103: WHERE blf.balance_type_id = X_Balance_Type_Id

Line 168: INSERT INTO pay_balance_feeds_f

164: FETCH C2 INTO l_balance_feed_id;
165: CLOSE C2;
166: end if;
167: --
168: INSERT INTO pay_balance_feeds_f
169: (balance_feed_id,
170: effective_start_date,
171: effective_end_date,
172: business_group_id,

Line 195: 'pay_balance_feeds_f_pkg.insert_row');

191: if (C%NOTFOUND) then
192: CLOSE C;
193: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
194: hr_utility.set_message_token('PROCEDURE',
195: 'pay_balance_feeds_f_pkg.insert_row');
196: hr_utility.set_message_token('STEP','1');
197: hr_utility.raise_error;
198: end if;
199: CLOSE C;

Line 227: CURSOR C IS SELECT * FROM pay_balance_feeds_f

223: X_Input_Value_Id NUMBER,
224: X_Scale NUMBER,
225: X_Legislation_Subgroup VARCHAR2) IS
226: --
227: CURSOR C IS SELECT * FROM pay_balance_feeds_f
228: WHERE rowid = X_Rowid FOR UPDATE of Balance_Feed_Id NOWAIT;
229: --
230: Recinfo C%ROWTYPE;
231: --

Line 240: 'pay_balance_feeds_f_pkg.lock_row');

236: if (C%NOTFOUND) then
237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_balance_feeds_f_pkg.lock_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: CLOSE C;

Line 359: UPDATE pay_balance_feeds_f

355: check_run_result_usage( X_Input_Value_Id ) ;
356: --
357: end if;
358: --
359: UPDATE pay_balance_feeds_f
360: SET balance_feed_id = X_Balance_Feed_Id,
361: effective_start_date = X_Effective_Start_Date,
362: effective_end_date = X_Effective_End_Date,
363: business_group_id = X_Business_Group_Id,

Line 374: 'pay_balance_feeds_f_pkg.update_row');

370: --
371: if (SQL%NOTFOUND) then
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE',
374: 'pay_balance_feeds_f_pkg.update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;
378: --

Line 432: DELETE FROM pay_balance_feeds_f

428: check_run_result_usage( X_Input_Value_Id ) ;
429: --
430: end if;
431: --
432: DELETE FROM pay_balance_feeds_f
433: WHERE rowid = X_Rowid;
434: --
435: if (SQL%NOTFOUND) then
436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 438: 'pay_balance_feeds_f_pkg.delete_row');

434: --
435: if (SQL%NOTFOUND) then
436: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
437: hr_utility.set_message_token('PROCEDURE',
438: 'pay_balance_feeds_f_pkg.delete_row');
439: hr_utility.set_message_token('STEP','1');
440: hr_utility.raise_error;
441: end if;
442: --

Line 477: END PAY_BALANCE_FEEDS_F_PKG;

473: END IF;
474: --
475: END check_run_result_usage ;
476: --
477: END PAY_BALANCE_FEEDS_F_PKG;