DBA Data[Home] [Help]

APPS.GHR_CAH_BUS dependencies on GHR_CAH_SHD

Line 189: ,p_rec in ghr_cah_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_cah_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_cah_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_cah_shd.api_updating
202: (p_compl_ca_header_id => p_rec.compl_ca_header_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_cah_shd.api_updating(

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

Line 266: ((nvl(ghr_cah_shd.g_old_rec.ca_source,hr_api.g_varchar2)

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

Line 340: l_api_updating := ghr_cah_shd.api_updating(

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

Line 346: ((nvl(ghr_cah_shd.g_old_rec.comrep_noncom_req,hr_api.g_varchar2)

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

Line 419: l_api_updating := ghr_cah_shd.api_updating(

415: -- b) The stage_complaint_reinstated value has changed
416: -- c) A record is being inserted.
417: --
418:
419: l_api_updating := ghr_cah_shd.api_updating(
420: p_compl_ca_header_id => p_compl_ca_header_id,
421: p_object_version_number => p_object_version_number);
422:
423: IF (l_api_updating

Line 425: ((nvl(ghr_cah_shd.g_old_rec.stage_complaint_reinstated,hr_api.g_varchar2)

421: p_object_version_number => p_object_version_number);
422:
423: IF (l_api_updating
424: AND
425: ((nvl(ghr_cah_shd.g_old_rec.stage_complaint_reinstated,hr_api.g_varchar2)
426: <> nvl(p_stage_complaint_reinstated,hr_api.g_varchar2))))
427: OR
428: NOT l_api_updating THEN
429:

Line 469: ,p_rec in ghr_cah_shd.g_rec_type

465: -- |---------------------------< insert_validate >----------------------------|
466: -- ----------------------------------------------------------------------------
467: Procedure insert_validate
468: (p_effective_date in date
469: ,p_rec in ghr_cah_shd.g_rec_type
470: ) is
471: --
472: l_proc varchar2(72) := g_package||'insert_validate';
473: --

Line 512: ,p_rec in ghr_cah_shd.g_rec_type

508: -- |---------------------------< update_validate >----------------------------|
509: -- ----------------------------------------------------------------------------
510: Procedure update_validate
511: (p_effective_date in date
512: ,p_rec in ghr_cah_shd.g_rec_type
513: ) is
514: --
515: l_proc varchar2(72) := g_package||'update_validate';
516: --

Line 559: (p_rec in ghr_cah_shd.g_rec_type

555: -- ----------------------------------------------------------------------------
556: -- |---------------------------< delete_validate >----------------------------|
557: -- ----------------------------------------------------------------------------
558: Procedure delete_validate
559: (p_rec in ghr_cah_shd.g_rec_type
560: ) is
561: --
562: l_proc varchar2(72) := g_package||'delete_validate';
563: --