DBA Data[Home] [Help]

APPS.IRC_ITA_BUS dependencies on IRC_ITA_SHD

Line 200: (p_rec in irc_ita_shd.g_rec_type

196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure chk_non_updateable_args
200: (p_rec in irc_ita_shd.g_rec_type
201: ) IS
202: --
203: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
204: l_error exception;

Line 213: IF NOT irc_ita_shd.api_updating

209: --
210: -- Only proceed with the validation if a row exists for the current
211: -- record in the HR Schema.
212: --
213: IF NOT irc_ita_shd.api_updating
214: (p_template_association_id => p_rec.template_association_id
215: ,p_object_version_number => p_rec.object_version_number
216: ) THEN
217: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 224: if irc_ita_shd.g_old_rec.template_association_id <> p_rec.template_association_id then

220: fnd_message.raise_error;
221: END IF;
222: --
223: --
224: if irc_ita_shd.g_old_rec.template_association_id <> p_rec.template_association_id then
225: hr_api.argument_changed_error
226: (p_api_name => l_proc
227: ,p_argument => 'template_association_id'
228: ,p_base_table => irc_ita_shd.g_tab_nam

Line 228: ,p_base_table => irc_ita_shd.g_tab_nam

224: if irc_ita_shd.g_old_rec.template_association_id <> p_rec.template_association_id then
225: hr_api.argument_changed_error
226: (p_api_name => l_proc
227: ,p_argument => 'template_association_id'
228: ,p_base_table => irc_ita_shd.g_tab_nam
229: );
230: end if;
231: --
232: exception

Line 282: l_api_updating := irc_ita_shd.api_updating

278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc,10);
281: --
282: l_api_updating := irc_ita_shd.api_updating
283: (p_template_association_id => p_template_association_id
284: ,p_object_version_number => p_object_version_number);
285: hr_utility.set_location(l_proc,20);
286: if ((l_api_updating

Line 288: nvl(irc_ita_shd.g_old_rec.template_id,hr_api.g_number) <>

284: ,p_object_version_number => p_object_version_number);
285: hr_utility.set_location(l_proc,20);
286: if ((l_api_updating
287: and
288: nvl(irc_ita_shd.g_old_rec.template_id,hr_api.g_number) <>
289: nvl(p_template_id, hr_api.g_number))
290: or
291: (NOT l_api_updating)) then
292: --

Line 377: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_organization_id is not null)

373: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
374: ) then
375: --
376:
377: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_organization_id is not null)
378: or (irc_ita_shd.g_old_rec.template_association_id is not null
379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)
380: <> nvl(p_organization_id, hr_api.g_number))) then
381: --

Line 378: or (irc_ita_shd.g_old_rec.template_association_id is not null

374: ) then
375: --
376:
377: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_organization_id is not null)
378: or (irc_ita_shd.g_old_rec.template_association_id is not null
379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)
380: <> nvl(p_organization_id, hr_api.g_number))) then
381: --
382: hr_utility.set_location(l_proc, 20);

Line 379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)

375: --
376:
377: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_organization_id is not null)
378: or (irc_ita_shd.g_old_rec.template_association_id is not null
379: and nvl(irc_ita_shd.g_old_rec.organization_id, hr_api.g_number)
380: <> nvl(p_organization_id, hr_api.g_number))) then
381: --
382: hr_utility.set_location(l_proc, 20);
383: --

Line 461: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_job_id is not null)

457: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
458: ) then
459: --
460:
461: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_job_id is not null)
462: or (irc_ita_shd.g_old_rec.template_association_id is not null
463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)
464: <> nvl(p_job_id, hr_api.g_number))) then
465: --

Line 462: or (irc_ita_shd.g_old_rec.template_association_id is not null

458: ) then
459: --
460:
461: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_job_id is not null)
462: or (irc_ita_shd.g_old_rec.template_association_id is not null
463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)
464: <> nvl(p_job_id, hr_api.g_number))) then
465: --
466: hr_utility.set_location(l_proc, 20);

Line 463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)

459: --
460:
461: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_job_id is not null)
462: or (irc_ita_shd.g_old_rec.template_association_id is not null
463: and nvl(irc_ita_shd.g_old_rec.job_id, hr_api.g_number)
464: <> nvl(p_job_id, hr_api.g_number))) then
465: --
466: hr_utility.set_location(l_proc, 20);
467: --

Line 549: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_position_id is not null)

545: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
546: ) then
547: --
548:
549: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_position_id is not null)
550: or (irc_ita_shd.g_old_rec.template_association_id is not null
551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)
552: <> nvl(p_position_id, hr_api.g_number))) then
553: --

Line 550: or (irc_ita_shd.g_old_rec.template_association_id is not null

546: ) then
547: --
548:
549: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_position_id is not null)
550: or (irc_ita_shd.g_old_rec.template_association_id is not null
551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)
552: <> nvl(p_position_id, hr_api.g_number))) then
553: --
554: hr_utility.set_location(l_proc, 20);

Line 551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)

547: --
548:
549: if ((irc_ita_shd.g_old_rec.template_association_id is null and p_position_id is not null)
550: or (irc_ita_shd.g_old_rec.template_association_id is not null
551: and nvl(irc_ita_shd.g_old_rec.position_id, hr_api.g_number)
552: <> nvl(p_position_id, hr_api.g_number))) then
553: --
554: hr_utility.set_location(l_proc, 20);
555: --

Line 845: l_api_updating := irc_ita_shd.api_updating

841: if hr_multi_message.no_exclusive_error
842: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
843: ) then
844: --
845: l_api_updating := irc_ita_shd.api_updating
846: (p_template_association_id => p_template_association_id
847: ,p_object_version_number => p_object_version_number);
848: --
849: hr_utility.set_location(l_proc,20);

Line 855: nvl(irc_ita_shd.g_old_rec.default_association,hr_api.g_varchar2)

851: -- Check if the value for default_association is set on insert or has
852: -- changed on update.
853: --
854: if ((nvl(p_default_association,hr_api.g_varchar2) <>
855: nvl(irc_ita_shd.g_old_rec.default_association,hr_api.g_varchar2)
856: and l_api_updating) or
857: (NOT l_api_updating))
858:
859: then

Line 934: l_api_updating := irc_ita_shd.api_updating

930: if hr_multi_message.no_exclusive_error
931: (p_check_column1 => 'IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID'
932: ) then
933: --
934: l_api_updating := irc_ita_shd.api_updating
935: (p_template_association_id => p_template_association_id
936: ,p_object_version_number => p_object_version_number);
937: --
938: hr_utility.set_location(l_proc,20);

Line 941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>

937: --
938: hr_utility.set_location(l_proc,20);
939: if ((l_api_updating
940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or
943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>
944: nvl(p_end_date, hr_api.g_date)))
945: or

Line 943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>

939: if ((l_api_updating
940: and
941: (nvl(irc_ita_shd.g_old_rec.start_date, hr_api.g_date) <>
942: nvl(p_start_date, hr_api.g_date) or
943: nvl(irc_ita_shd.g_old_rec.end_date, hr_api.g_date) <>
944: nvl(p_end_date, hr_api.g_date)))
945: or
946: (NOT l_api_updating)) then
947: --

Line 984: ,p_rec in irc_ita_shd.g_rec_type

980: -- |---------------------------< insert_validate >----------------------------|
981: -- ----------------------------------------------------------------------------
982: Procedure insert_validate
983: (p_effective_date in date
984: ,p_rec in irc_ita_shd.g_rec_type
985: ) is
986: --
987: l_proc varchar2(72) := g_package||'insert_validate';
988: --

Line 1072: ,p_rec in irc_ita_shd.g_rec_type

1068: -- |---------------------------< update_validate >----------------------------|
1069: -- ----------------------------------------------------------------------------
1070: Procedure update_validate
1071: (p_effective_date in date
1072: ,p_rec in irc_ita_shd.g_rec_type
1073: ) is
1074: --
1075: l_proc varchar2(72) := g_package||'update_validate';
1076: --

Line 1160: (p_rec in irc_ita_shd.g_rec_type

1156: -- ----------------------------------------------------------------------------
1157: -- |---------------------------< delete_validate >----------------------------|
1158: -- ----------------------------------------------------------------------------
1159: Procedure delete_validate
1160: (p_rec in irc_ita_shd.g_rec_type
1161: ) is
1162: --
1163: l_proc varchar2(72) := g_package||'delete_validate';
1164: --