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.PQH_BRE_UPD dependencies on HR_API

Line 92: When hr_api.check_integrity_violated Then

88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
95: pqh_bre_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
95: pqh_bre_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
100: pqh_bre_shd.constraint_error

Line 97: When hr_api.parent_integrity_violated Then

93: -- A check constraint has been violated
94: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
95: pqh_bre_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
100: pqh_bre_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
100: pqh_bre_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
105: pqh_bre_shd.constraint_error

Line 102: When hr_api.unique_integrity_violated Then

98: -- Parent integrity has been violated
99: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
100: pqh_bre_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
105: pqh_bre_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
105: pqh_bre_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;
110: End update_dml;

Line 255: when hr_api.cannot_find_prog_unit then

251: );
252: --
253: exception
254: --
255: when hr_api.cannot_find_prog_unit then
256: --
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'PQH_BDGT_POOL_REALLOCTIONS'
259: ,p_hook_type => 'AU');

Line 257: hr_api.cannot_find_prog_unit_error

253: exception
254: --
255: when hr_api.cannot_find_prog_unit then
256: --
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'PQH_BDGT_POOL_REALLOCTIONS'
259: ,p_hook_type => 'AU');
260: --
261: end;

Line 320: If (p_rec.position_id = hr_api.g_number) then

316: -- p_rec plsql record structure
317: -- to see if a system default is being used. If a system default
318: -- is being used then we must set to the 'current' argument value.
319: --
320: If (p_rec.position_id = hr_api.g_number) then
321: p_rec.position_id :=
322: pqh_bre_shd.g_old_rec.position_id;
323: End If;
324: If (p_rec.pool_id = hr_api.g_number) then

Line 324: If (p_rec.pool_id = hr_api.g_number) then

320: If (p_rec.position_id = hr_api.g_number) then
321: p_rec.position_id :=
322: pqh_bre_shd.g_old_rec.position_id;
323: End If;
324: If (p_rec.pool_id = hr_api.g_number) then
325: p_rec.pool_id :=
326: pqh_bre_shd.g_old_rec.pool_id;
327: End If;
328: If (p_rec.reallocation_amt = hr_api.g_number) then

Line 328: If (p_rec.reallocation_amt = hr_api.g_number) then

324: If (p_rec.pool_id = hr_api.g_number) then
325: p_rec.pool_id :=
326: pqh_bre_shd.g_old_rec.pool_id;
327: End If;
328: If (p_rec.reallocation_amt = hr_api.g_number) then
329: p_rec.reallocation_amt :=
330: pqh_bre_shd.g_old_rec.reallocation_amt;
331: End If;
332: If (p_rec.reserved_amt = hr_api.g_number) then

Line 332: If (p_rec.reserved_amt = hr_api.g_number) then

328: If (p_rec.reallocation_amt = hr_api.g_number) then
329: p_rec.reallocation_amt :=
330: pqh_bre_shd.g_old_rec.reallocation_amt;
331: End If;
332: If (p_rec.reserved_amt = hr_api.g_number) then
333: p_rec.reserved_amt :=
334: pqh_bre_shd.g_old_rec.reserved_amt;
335: End If;
336: If (p_rec.txn_detail_id = hr_api.g_number) then

Line 336: If (p_rec.txn_detail_id = hr_api.g_number) then

332: If (p_rec.reserved_amt = hr_api.g_number) then
333: p_rec.reserved_amt :=
334: pqh_bre_shd.g_old_rec.reserved_amt;
335: End If;
336: If (p_rec.txn_detail_id = hr_api.g_number) then
337: p_rec.txn_detail_id :=
338: pqh_bre_shd.g_old_rec.txn_detail_id;
339: End If;
340: If (p_rec.transaction_type = hr_api.g_varchar2) then

Line 340: If (p_rec.transaction_type = hr_api.g_varchar2) then

336: If (p_rec.txn_detail_id = hr_api.g_number) then
337: p_rec.txn_detail_id :=
338: pqh_bre_shd.g_old_rec.txn_detail_id;
339: End If;
340: If (p_rec.transaction_type = hr_api.g_varchar2) then
341: p_rec.transaction_type :=
342: pqh_bre_shd.g_old_rec.transaction_type;
343: End If;
344: If (p_rec.budget_detail_id = hr_api.g_number) then

Line 344: If (p_rec.budget_detail_id = hr_api.g_number) then

340: If (p_rec.transaction_type = hr_api.g_varchar2) then
341: p_rec.transaction_type :=
342: pqh_bre_shd.g_old_rec.transaction_type;
343: End If;
344: If (p_rec.budget_detail_id = hr_api.g_number) then
345: p_rec.budget_detail_id :=
346: pqh_bre_shd.g_old_rec.budget_detail_id;
347: End If;
348: If (p_rec.budget_period_id = hr_api.g_number) then

Line 348: If (p_rec.budget_period_id = hr_api.g_number) then

344: If (p_rec.budget_detail_id = hr_api.g_number) then
345: p_rec.budget_detail_id :=
346: pqh_bre_shd.g_old_rec.budget_detail_id;
347: End If;
348: If (p_rec.budget_period_id = hr_api.g_number) then
349: p_rec.budget_period_id :=
350: pqh_bre_shd.g_old_rec.budget_period_id;
351: End If;
352: If (p_rec.entity_id = hr_api.g_number) then

Line 352: If (p_rec.entity_id = hr_api.g_number) then

348: If (p_rec.budget_period_id = hr_api.g_number) then
349: p_rec.budget_period_id :=
350: pqh_bre_shd.g_old_rec.budget_period_id;
351: End If;
352: If (p_rec.entity_id = hr_api.g_number) then
353: p_rec.entity_id :=
354: pqh_bre_shd.g_old_rec.entity_id;
355: End If;
356: If (p_rec.start_date = hr_api.g_date) then

Line 356: If (p_rec.start_date = hr_api.g_date) then

352: If (p_rec.entity_id = hr_api.g_number) then
353: p_rec.entity_id :=
354: pqh_bre_shd.g_old_rec.entity_id;
355: End If;
356: If (p_rec.start_date = hr_api.g_date) then
357: p_rec.start_date :=
358: pqh_bre_shd.g_old_rec.start_date;
359: End If;
360: If (p_rec.end_date = hr_api.g_date) then

Line 360: If (p_rec.end_date = hr_api.g_date) then

356: If (p_rec.start_date = hr_api.g_date) then
357: p_rec.start_date :=
358: pqh_bre_shd.g_old_rec.start_date;
359: End If;
360: If (p_rec.end_date = hr_api.g_date) then
361: p_rec.end_date :=
362: pqh_bre_shd.g_old_rec.end_date;
363: End If;
364: --

Line 428: ,p_position_id in number default hr_api.g_number

424: Procedure upd
425: (p_effective_date in date
426: ,p_reallocation_id in number
427: ,p_object_version_number in out nocopy number
428: ,p_position_id in number default hr_api.g_number
429: ,p_pool_id in number default hr_api.g_number
430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number

Line 429: ,p_pool_id in number default hr_api.g_number

425: (p_effective_date in date
426: ,p_reallocation_id in number
427: ,p_object_version_number in out nocopy number
428: ,p_position_id in number default hr_api.g_number
429: ,p_pool_id in number default hr_api.g_number
430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2

Line 430: ,p_reallocation_amt in number default hr_api.g_number

426: ,p_reallocation_id in number
427: ,p_object_version_number in out nocopy number
428: ,p_position_id in number default hr_api.g_number
429: ,p_pool_id in number default hr_api.g_number
430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number

Line 431: ,p_reserved_amt in number default hr_api.g_number

427: ,p_object_version_number in out nocopy number
428: ,p_position_id in number default hr_api.g_number
429: ,p_pool_id in number default hr_api.g_number
430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number

Line 432: ,p_txn_detail_id in number default hr_api.g_number

428: ,p_position_id in number default hr_api.g_number
429: ,p_pool_id in number default hr_api.g_number
430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number

Line 433: ,p_transaction_type in varchar2 default hr_api.g_varchar2

429: ,p_pool_id in number default hr_api.g_number
430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number
437: ,p_start_date in date default hr_api.g_date

Line 434: ,p_budget_detail_id in number default hr_api.g_number

430: ,p_reallocation_amt in number default hr_api.g_number
431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date

Line 435: ,p_budget_period_id in number default hr_api.g_number

431: ,p_reserved_amt in number default hr_api.g_number
432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ) is

Line 436: ,p_entity_id in number default hr_api.g_number

432: ,p_txn_detail_id in number default hr_api.g_number
433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ) is
440: --

Line 437: ,p_start_date in date default hr_api.g_date

433: ,p_transaction_type in varchar2 default hr_api.g_varchar2
434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ) is
440: --
441: l_rec pqh_bre_shd.g_rec_type;

Line 438: ,p_end_date in date default hr_api.g_date

434: ,p_budget_detail_id in number default hr_api.g_number
435: ,p_budget_period_id in number default hr_api.g_number
436: ,p_entity_id in number default hr_api.g_number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ) is
440: --
441: l_rec pqh_bre_shd.g_rec_type;
442: l_proc varchar2(72) := g_package||'upd';