DBA Data[Home] [Help]

APPS.GHR_CCA_BUS dependencies on GHR_CCA_SHD

Line 189: ,p_rec in ghr_cca_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_cca_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_cca_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_cca_shd.api_updating
202: (p_compl_appeal_id => p_rec.compl_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 259: l_api_updating := ghr_cca_shd.api_updating(

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

Line 265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)

261: p_object_version_number => p_object_version_number);
262:
263: IF (l_api_updating
264: AND
265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)
266: <> nvl(p_appealed_to,hr_api.g_varchar2))))
267: OR
268: NOT l_api_updating THEN
269:

Line 339: l_api_updating := ghr_cca_shd.api_updating(

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

Line 345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)

341: p_object_version_number => p_object_version_number);
342:
343: IF (l_api_updating
344: AND
345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
346: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
347: OR
348: NOT l_api_updating THEN
349:

Line 424: l_api_updating := ghr_cca_shd.api_updating(

420: -- b) The decision value has changed
421: -- c) A record is being inserted.
422: --
423:
424: l_api_updating := ghr_cca_shd.api_updating(
425: p_compl_appeal_id => p_compl_appeal_id,
426: p_object_version_number => p_object_version_number);
427:
428: IF (l_api_updating

Line 430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)

426: p_object_version_number => p_object_version_number);
427:
428: IF (l_api_updating
429: AND
430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)
431: <> nvl(p_decision,hr_api.g_varchar2))))
432: OR
433: NOT l_api_updating THEN
434:

Line 514: l_api_updating := ghr_cca_shd.api_updating(

510: -- b) The rfr_requested_by value has changed
511: -- c) A record is being inserted.
512: --
513:
514: l_api_updating := ghr_cca_shd.api_updating(
515: p_compl_appeal_id => p_compl_appeal_id,
516: p_object_version_number => p_object_version_number);
517:
518: IF (l_api_updating

Line 520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)

516: p_object_version_number => p_object_version_number);
517:
518: IF (l_api_updating
519: AND
520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
521: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
522: OR
523: NOT l_api_updating THEN
524:

Line 594: l_api_updating := ghr_cca_shd.api_updating(

590: -- b) The rfr_decision value has changed
591: -- c) A record is being inserted.
592: --
593:
594: l_api_updating := ghr_cca_shd.api_updating(
595: p_compl_appeal_id => p_compl_appeal_id,
596: p_object_version_number => p_object_version_number);
597:
598: IF (l_api_updating

Line 600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)

596: p_object_version_number => p_object_version_number);
597:
598: IF (l_api_updating
599: AND
600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
601: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
602: OR
603: NOT l_api_updating THEN
604:

Line 644: ,p_rec in ghr_cca_shd.g_rec_type

640: -- |---------------------------< insert_validate >----------------------------|
641: -- ----------------------------------------------------------------------------
642: Procedure insert_validate
643: (p_effective_date in date
644: ,p_rec in ghr_cca_shd.g_rec_type
645: ) is
646: --
647: l_proc varchar2(72) := g_package||'insert_validate';
648: --

Line 699: ,p_rec in ghr_cca_shd.g_rec_type

695: -- |---------------------------< update_validate >----------------------------|
696: -- ----------------------------------------------------------------------------
697: Procedure update_validate
698: (p_effective_date in date
699: ,p_rec in ghr_cca_shd.g_rec_type
700: ) is
701: --
702: l_proc varchar2(72) := g_package||'update_validate';
703: --

Line 757: (p_rec in ghr_cca_shd.g_rec_type

753: -- ----------------------------------------------------------------------------
754: -- |---------------------------< delete_validate >----------------------------|
755: -- ----------------------------------------------------------------------------
756: Procedure delete_validate
757: (p_rec in ghr_cca_shd.g_rec_type
758: ) is
759: --
760: l_proc varchar2(72) := g_package||'delete_validate';
761: --