APPS.AME_APG_BUS dependencies on AME_APG_SHD

Line 336: ,p_rec in ame_apg_shd.g_rec_type

332: -- {End Of Comments}
333: -- ----------------------------------------------------------------------------
334: Procedure chk_non_updateable_args
335: (p_effective_date in date
336: ,p_rec in ame_apg_shd.g_rec_type
337: ) IS
338: --
339: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
340: l_created_by ame_approval_groups.created_by%TYPE;

Line 355: IF NOT ame_apg_shd.api_updating

351: --
352: -- Only proceed with the validation if a row exists for the current
353: -- record in the HR Schema.
354: --
355: IF NOT ame_apg_shd.api_updating
356: (p_approval_group_id => p_rec.approval_group_id
357: ,p_effective_date => p_effective_date
358: ,p_object_version_number => p_rec.object_version_number
359: ) THEN

Line 380: nvl(ame_apg_shd.g_old_rec.name,hr_api.g_varchar2)then

376: -- NAME is non-updateable if the group is seeded
377:
378: --if l_created_by = ame_util.seededDataCreatedById and
379: if nvl(p_rec.name, hr_api.g_varchar2) <>
380: nvl(ame_apg_shd.g_old_rec.name,hr_api.g_varchar2)then
381: hr_api.argument_changed_error
382: (p_api_name => l_proc
383: ,p_argument => 'NAME'
384: ,p_base_table => ame_con_shd.g_tab_nam

Line 392: -- nvl(ame_apg_shd.g_old_rec.description,hr_api.g_varchar2)then

388: -- DESCRIPTION is non-updateable if the group is seeded
389:
390: -- if l_created_by = ame_util.seededDataCreatedById and
391: -- nvl(p_rec.description, hr_api.g_varchar2) <>
392: -- nvl(ame_apg_shd.g_old_rec.description,hr_api.g_varchar2)then
393: -- hr_api.argument_changed_error
394: -- (p_api_name => l_proc
395: -- ,p_argument => 'DESCRIPTION'
396: -- ,p_base_table => ame_con_shd.g_tab_nam

Line 404: -- nvl(ame_apg_shd.g_old_rec.is_static,hr_api.g_varchar2)then

400: -- IS_STATIC is non-updateable if the group is seeded
401:
402: --if l_created_by = ame_util.seededDataCreatedById and
403: -- nvl(p_rec.is_static, hr_api.g_varchar2) <>
404: -- nvl(ame_apg_shd.g_old_rec.is_static,hr_api.g_varchar2)then
405: -- hr_api.argument_changed_error
406: -- (p_api_name => l_proc
407: -- ,p_argument => 'IS_STATIC'
408: -- ,p_base_table => ame_con_shd.g_tab_nam

Line 416: -- nvl(ame_apg_shd.g_old_rec.query_string,hr_api.g_varchar2)then

412: -- QUERY_STRING is non-updateable if the group is seeded
413:
414: -- if l_created_by = ame_util.seededDataCreatedById and
415: -- nvl(p_rec.query_string, hr_api.g_varchar2) <>
416: -- nvl(ame_apg_shd.g_old_rec.query_string,hr_api.g_varchar2)then
417: -- hr_api.argument_changed_error
418: -- (p_api_name => l_proc
419: -- ,p_argument => 'QUERY_STRING'
420: -- ,p_base_table => ame_con_shd.g_tab_nam

Line 581: ame_apg_shd.child_rows_exist

577: ,p_argument => 'approval_group_id'
578: ,p_argument_value => p_approval_group_id
579: );
580: --
581: ame_apg_shd.child_rows_exist
582: (p_ => p_approval_group_id
583: ,p_start_date => p_validation_start_date
584: ,p_end_date => p_validation_end_date);
585: --

Line 606: (p_rec in ame_apg_shd.g_rec_type

602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< insert_validate >----------------------------|
604: -- ----------------------------------------------------------------------------
605: Procedure insert_validate
606: (p_rec in ame_apg_shd.g_rec_type
607: ,p_effective_date in date
608: ,p_datetrack_mode in varchar2
609: ,p_validation_start_date in date
610: ,p_validation_end_date in date

Line 648: (p_rec in ame_apg_shd.g_rec_type

644: -- ----------------------------------------------------------------------------
645: -- |---------------------------< update_validate >----------------------------|
646: -- ----------------------------------------------------------------------------
647: Procedure update_validate
648: (p_rec in ame_apg_shd.g_rec_type
649: ,p_effective_date in date
650: ,p_datetrack_mode in varchar2
651: ,p_validation_start_date in date
652: ,p_validation_end_date in date

Line 686: /*if (p_rec.name <> ame_apg_shd.g_old_rec.name) then

682: chk_name (
683: p_name => p_rec.name
684: );
685: --name is non updateable, so following code is commented
686: /*if (p_rec.name <> ame_apg_shd.g_old_rec.name) then
687: chk_unique (
688: p_name => p_rec.name
689: ,p_effective_date => p_effective_date
690: );

Line 708: (p_rec in ame_apg_shd.g_rec_type

704: -- ----------------------------------------------------------------------------
705: -- |---------------------------< delete_validate >----------------------------|
706: -- ----------------------------------------------------------------------------
707: Procedure delete_validate
708: (p_rec in ame_apg_shd.g_rec_type
709: ,p_effective_date in date
710: ,p_datetrack_mode in varchar2
711: ,p_validation_start_date in date
712: ,p_validation_end_date in date