DBA Data[Home] [Help]

APPS.GHR_CAA_BUS dependencies on GHR_CAA_SHD

Line 189: ,p_rec in ghr_caa_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure chk_non_updateable_args
188: (p_effective_date in date
189: ,p_rec in ghr_caa_shd.g_rec_type
190: ) IS
191: --
192: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
193: l_error EXCEPTION;

Line 201: IF NOT ghr_caa_shd.api_updating

197: --
198: -- Only proceed with the validation if a row exists for the current
199: -- record in the HR Schema.
200: --
201: IF NOT ghr_caa_shd.api_updating
202: (p_compl_agency_appeal_id => p_rec.compl_agency_appeal_id
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 260: l_api_updating := ghr_caa_shd.api_updating(

256: -- b) The reason_for_appeal value has changed
257: -- c) A record is being inserted.
258: --
259:
260: l_api_updating := ghr_caa_shd.api_updating(
261: p_compl_agency_appeal_id => p_compl_agency_appeal_id,
262: p_object_version_number => p_object_version_number);
263:
264: IF (l_api_updating

Line 266: ((nvl(ghr_caa_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263:
264: IF (l_api_updating
265: AND
266: ((nvl(ghr_caa_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
267: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
268: OR
269: NOT l_api_updating THEN
270:

Line 340: l_api_updating := ghr_caa_shd.api_updating(

336: -- b) The decision value has changed
337: -- c) A record is being inserted.
338: --
339:
340: l_api_updating := ghr_caa_shd.api_updating(
341: p_compl_agency_appeal_id => p_compl_agency_appeal_id,
342: p_object_version_number => p_object_version_number);
343:
344: IF (l_api_updating

Line 346: ((nvl(ghr_caa_shd.g_old_rec.decision,hr_api.g_varchar2)

342: p_object_version_number => p_object_version_number);
343:
344: IF (l_api_updating
345: AND
346: ((nvl(ghr_caa_shd.g_old_rec.decision,hr_api.g_varchar2)
347: <> nvl(p_decision,hr_api.g_varchar2))))
348: OR
349: NOT l_api_updating THEN
350:

Line 421: l_api_updating := ghr_caa_shd.api_updating(

417: -- b) The rfr_requested_by value has changed
418: -- c) A record is being inserted.
419: --
420:
421: l_api_updating := ghr_caa_shd.api_updating(
422: p_compl_agency_appeal_id => p_compl_agency_appeal_id,
423: p_object_version_number => p_object_version_number);
424:
425: IF (l_api_updating

Line 427: ((nvl(ghr_caa_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)

423: p_object_version_number => p_object_version_number);
424:
425: IF (l_api_updating
426: AND
427: ((nvl(ghr_caa_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
428: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
429: OR
430: NOT l_api_updating THEN
431:

Line 501: l_api_updating := ghr_caa_shd.api_updating(

497: -- b) The rfr_decision value has changed
498: -- c) A record is being inserted.
499: --
500:
501: l_api_updating := ghr_caa_shd.api_updating(
502: p_compl_agency_appeal_id => p_compl_agency_appeal_id,
503: p_object_version_number => p_object_version_number);
504:
505: IF (l_api_updating

Line 507: ((nvl(ghr_caa_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)

503: p_object_version_number => p_object_version_number);
504:
505: IF (l_api_updating
506: AND
507: ((nvl(ghr_caa_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
508: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
509: OR
510: NOT l_api_updating THEN
511:

Line 551: ,p_rec in ghr_caa_shd.g_rec_type

547: -- |---------------------------< insert_validate >----------------------------|
548: -- ----------------------------------------------------------------------------
549: Procedure insert_validate
550: (p_effective_date in date
551: ,p_rec in ghr_caa_shd.g_rec_type
552: ) is
553: --
554: l_proc varchar2(72) := g_package||'insert_validate';
555: --

Line 599: ,p_rec in ghr_caa_shd.g_rec_type

595: -- |---------------------------< update_validate >----------------------------|
596: -- ----------------------------------------------------------------------------
597: Procedure update_validate
598: (p_effective_date in date
599: ,p_rec in ghr_caa_shd.g_rec_type
600: ) is
601: --
602: l_proc varchar2(72) := g_package||'update_validate';
603: --

Line 653: (p_rec in ghr_caa_shd.g_rec_type

649: -- ----------------------------------------------------------------------------
650: -- |---------------------------< delete_validate >----------------------------|
651: -- ----------------------------------------------------------------------------
652: Procedure delete_validate
653: (p_rec in ghr_caa_shd.g_rec_type
654: ) is
655: --
656: l_proc varchar2(72) := g_package||'delete_validate';
657: --