DBA Data[Home] [Help]

APPS.IRC_RTM_BUS dependencies on IRC_RTM_SHD

Line 109: (p_rec in irc_rtm_shd.g_rec_type

105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure chk_non_updateable_args
109: (p_rec in irc_rtm_shd.g_rec_type
110: ) IS
111: --
112: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
113: --

Line 120: IF NOT irc_rtm_shd.api_updating

116: --
117: -- Only proceed with the validation if a row exists for the current
118: -- record in the HR Schema.
119: --
120: IF NOT irc_rtm_shd.api_updating
121: (p_rec_team_member_id => p_rec.rec_team_member_id
122: ,p_object_version_number => p_rec.object_version_number
123: ) THEN
124: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 133: if p_rec.rec_team_member_id <> irc_rtm_shd.g_old_rec.rec_team_member_id

129: --
130: -- Add checks to ensure non-updateable args have
131: -- not been updated.
132: --
133: if p_rec.rec_team_member_id <> irc_rtm_shd.g_old_rec.rec_team_member_id
134: then
135: hr_api.argument_changed_error
136: (p_api_name => l_proc
137: ,p_argument => 'REC_TEAM_MEMBER_ID'

Line 138: ,p_base_table => irc_rtm_shd.g_tab_name

134: then
135: hr_api.argument_changed_error
136: (p_api_name => l_proc
137: ,p_argument => 'REC_TEAM_MEMBER_ID'
138: ,p_base_table => irc_rtm_shd.g_tab_name
139: );
140: end if;
141: --
142: if p_rec.vacancy_id <> irc_rtm_shd.g_old_rec.vacancy_id

Line 142: if p_rec.vacancy_id <> irc_rtm_shd.g_old_rec.vacancy_id

138: ,p_base_table => irc_rtm_shd.g_tab_name
139: );
140: end if;
141: --
142: if p_rec.vacancy_id <> irc_rtm_shd.g_old_rec.vacancy_id
143: then
144: hr_api.argument_changed_error
145: (p_api_name => l_proc
146: ,p_argument => 'VACANCY_ID'

Line 147: ,p_base_table => irc_rtm_shd.g_tab_name

143: then
144: hr_api.argument_changed_error
145: (p_api_name => l_proc
146: ,p_argument => 'VACANCY_ID'
147: ,p_base_table => irc_rtm_shd.g_tab_name
148: );
149: end if;
150: --
151: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 408: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id

404: Begin
405: --
406: hr_utility.set_location(' Entering:'||l_proc,10);
407: --
408: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
409: ,p_object_version_number);
410: --
411: hr_utility.set_location(l_proc, 30);
412: if(p_job_id IS NOT NULL) then

Line 414: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))

410: --
411: hr_utility.set_location(l_proc, 30);
412: if(p_job_id IS NOT NULL) then
413: if ((l_api_updating
414: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))
415: or (NOT l_api_updating)) then
416: --
417: -- Check if the job_id exists in PER_JOBS
418: --

Line 503: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id

499: Begin
500: --
501: hr_utility.set_location(' Entering:'||l_proc,10);
502: --
503: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
504: ,p_object_version_number);
505: --
506: if(p_job_id IS NOT NULL) then
507: if ((l_api_updating

Line 508: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))

504: ,p_object_version_number);
505: --
506: if(p_job_id IS NOT NULL) then
507: if ((l_api_updating
508: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))
509: or (NOT l_api_updating)) then
510: hr_utility.set_location(l_proc, 20);
511: --
512: -- Check if the job_group_id exists in PER_JOB_GROUPS and is valid.

Line 586: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id

582: --
583: hr_utility.set_location(' Entering:'||l_proc,10);
584: if (p_start_date is not NULL or p_end_date is not NULL) then
585: --
586: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
587: ,p_object_version_number);
588: --
589: -- Check to see if start_date or end_date values have changed.
590: --

Line 593: and ((nvl(irc_rtm_shd.g_old_rec.start_date,hr_api.g_sot)

589: -- Check to see if start_date or end_date values have changed.
590: --
591: hr_utility.set_location(l_proc, 30);
592: if ((l_api_updating
593: and ((nvl(irc_rtm_shd.g_old_rec.start_date,hr_api.g_sot)
594: <> p_start_date)
595: or (nvl(irc_rtm_shd.g_old_rec.end_date,hr_api.g_eot) <> p_end_date)))
596: or (NOT l_api_updating)) then
597: --

Line 595: or (nvl(irc_rtm_shd.g_old_rec.end_date,hr_api.g_eot) <> p_end_date)))

591: hr_utility.set_location(l_proc, 30);
592: if ((l_api_updating
593: and ((nvl(irc_rtm_shd.g_old_rec.start_date,hr_api.g_sot)
594: <> p_start_date)
595: or (nvl(irc_rtm_shd.g_old_rec.end_date,hr_api.g_eot) <> p_end_date)))
596: or (NOT l_api_updating)) then
597: --
598: -- Check that the end date is not before the start date.
599: --

Line 666: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id

662: --
663: hr_utility.set_location(' Entering:'||l_proc,10);
664: if (p_update_allowed is not NULL) then
665: --
666: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
667: ,p_object_version_number);
668: --
669: -- Check to see if the update_allowed value has changed.
670: --

Line 673: and (irc_rtm_shd.g_old_rec.update_allowed <> p_update_allowed))

669: -- Check to see if the update_allowed value has changed.
670: --
671: hr_utility.set_location(l_proc, 30);
672: if ((l_api_updating
673: and (irc_rtm_shd.g_old_rec.update_allowed <> p_update_allowed))
674: or (NOT l_api_updating)) then
675: --
676: -- Check that a valid 'Update Allowed' value is entered.
677: --

Line 748: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id,p_object_version_number);

744: --
745: hr_utility.set_location(' Entering:'||l_proc,10);
746: if (p_delete_allowed is not NULL) then
747: --
748: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id,p_object_version_number);
749: --
750: -- Check to see if the delete_allowed value has changed.
751: --
752: hr_utility.set_location(l_proc, 30);

Line 754: and (irc_rtm_shd.g_old_rec.delete_allowed <> p_delete_allowed))

750: -- Check to see if the delete_allowed value has changed.
751: --
752: hr_utility.set_location(l_proc, 30);
753: if ((l_api_updating
754: and (irc_rtm_shd.g_old_rec.delete_allowed <> p_delete_allowed))
755: or (NOT l_api_updating)) then
756: --
757: -- Check that a valid 'Delete Allowed' value is entered.
758: --

Line 870: (p_rec in out nocopy irc_rtm_shd.g_rec_type

866: -- ----------------------------------------------------------------------------
867: -- |---------------------------< insert_validate >----------------------------|
868: -- ----------------------------------------------------------------------------
869: Procedure insert_validate
870: (p_rec in out nocopy irc_rtm_shd.g_rec_type
871: ) is
872: --
873: l_proc varchar2(72) := g_package||'insert_validate';
874: --

Line 948: (p_rec in out nocopy irc_rtm_shd.g_rec_type

944: -- ----------------------------------------------------------------------------
945: -- |---------------------------< update_validate >----------------------------|
946: -- ----------------------------------------------------------------------------
947: Procedure update_validate
948: (p_rec in out nocopy irc_rtm_shd.g_rec_type
949: ) is
950: --
951: l_proc varchar2(72) := g_package||'update_validate';
952: --

Line 1021: (p_rec in irc_rtm_shd.g_rec_type

1017: -- ----------------------------------------------------------------------------
1018: -- |---------------------------< delete_validate >----------------------------|
1019: -- ----------------------------------------------------------------------------
1020: Procedure delete_validate
1021: (p_rec in irc_rtm_shd.g_rec_type
1022: ) is
1023: --
1024: l_proc varchar2(72) := g_package||'delete_validate';
1025: --