DBA Data[Home] [Help]

APPS.IRC_IVC_BUS dependencies on IRC_IVC_SHD

Line 110: ,p_rec in irc_ivc_shd.g_rec_type

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

Line 120: IF NOT irc_ivc_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_ivc_shd.api_updating
121: (p_vacancy_consideration_id => p_rec.vacancy_consideration_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 132: if p_rec.vacancy_consideration_id <> irc_ivc_shd.g_old_rec.vacancy_consideration_id

128: END IF;
129: --
130: -- Checks to ensure non-updateable args have
131: -- not been updated.
132: if p_rec.vacancy_consideration_id <> irc_ivc_shd.g_old_rec.vacancy_consideration_id
133: then
134: hr_api.argument_changed_error
135: (p_api_name => l_proc
136: ,p_argument => 'VACANCY_CONSIDERATION_ID'

Line 137: ,p_base_table => irc_ivc_shd.g_tab_nam

133: then
134: hr_api.argument_changed_error
135: (p_api_name => l_proc
136: ,p_argument => 'VACANCY_CONSIDERATION_ID'
137: ,p_base_table => irc_ivc_shd.g_tab_nam
138: );
139: end if;
140: --
141: if p_rec.vacancy_id <> irc_ivc_shd.g_old_rec.vacancy_id

Line 141: if p_rec.vacancy_id <> irc_ivc_shd.g_old_rec.vacancy_id

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

Line 146: ,p_base_table => irc_ivc_shd.g_tab_nam

142: then
143: hr_api.argument_changed_error
144: (p_api_name => l_proc
145: ,p_argument => 'VACANCY_ID'
146: ,p_base_table => irc_ivc_shd.g_tab_nam
147: );
148: end if;
149: --
150: if p_rec.person_id <> irc_ivc_shd.g_old_rec.person_id

Line 150: if p_rec.person_id <> irc_ivc_shd.g_old_rec.person_id

146: ,p_base_table => irc_ivc_shd.g_tab_nam
147: );
148: end if;
149: --
150: if p_rec.person_id <> irc_ivc_shd.g_old_rec.person_id
151: then
152: hr_api.argument_changed_error
153: (p_api_name => l_proc
154: ,p_argument => 'PERSON_ID'

Line 155: ,p_base_table => irc_ivc_shd.g_tab_nam

151: then
152: hr_api.argument_changed_error
153: (p_api_name => l_proc
154: ,p_argument => 'PERSON_ID'
155: ,p_base_table => irc_ivc_shd.g_tab_nam
156: );
157: end if;
158: --
159: End chk_non_updateable_args;

Line 404: l_api_updating := irc_ivc_shd.api_updating(p_vacancy_consideration_id

400: Begin
401: --
402: hr_utility.set_location(' Entering:'||l_proc,10);
403: --
404: l_api_updating := irc_ivc_shd.api_updating(p_vacancy_consideration_id
405: ,p_object_version_number);
406: --
407: -- Check to see if the consideration_status value has changed
408: --

Line 411: and (irc_ivc_shd.g_old_rec.consideration_status <>

407: -- Check to see if the consideration_status value has changed
408: --
409: hr_utility.set_location(l_proc, 20);
410: if ((l_api_updating
411: and (irc_ivc_shd.g_old_rec.consideration_status <>
412: p_consideration_status))
413: or (NOT l_api_updating)) then
414: --
415: -- Check that a valid 'Consideration Status' value is entered.

Line 432: if(l_api_updating and irc_ivc_shd.g_old_rec.consideration_status = 'PURSUE'

428: -- Check that the updated consideration status value is 'Pursue' if the
429: -- old value was 'Pursue'
430: --
431: hr_utility.set_location(l_proc, 40);
432: if(l_api_updating and irc_ivc_shd.g_old_rec.consideration_status = 'PURSUE'
433: and (p_consideration_status <> 'PURSUE')) then
434: fnd_message.set_name('PER','IRC_412049_IVC_INV_UPD_CONS_ST');
435: fnd_message.raise_error;
436: end if;

Line 444: irc_ivc_shd.g_tab_nam||'.CONSIDERATION_STATUS'

440: exception
441: when app_exception.application_exception then
442: if hr_multi_message.exception_add
443: (p_associated_column1 =>
444: irc_ivc_shd.g_tab_nam||'.CONSIDERATION_STATUS'
445: ) then
446: hr_utility.set_location(' Leaving:'|| l_proc, 80);
447: raise;
448: end if;

Line 458: ,p_rec in out nocopy irc_ivc_shd.g_rec_type

454: -- |---------------------------< insert_validate >----------------------------|
455: -- ----------------------------------------------------------------------------
456: Procedure insert_validate
457: (p_effective_date in date
458: ,p_rec in out nocopy irc_ivc_shd.g_rec_type
459: ) is
460: --
461: l_proc varchar2(72) := g_package||'insert_validate';
462: --

Line 498: ,p_rec in irc_ivc_shd.g_rec_type

494: -- |---------------------------< update_validate >----------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure update_validate
497: (p_effective_date in date
498: ,p_rec in irc_ivc_shd.g_rec_type
499: ) is
500: --
501: l_proc varchar2(72) := g_package||'update_validate';
502: --

Line 532: (p_rec in irc_ivc_shd.g_rec_type

528: -- ----------------------------------------------------------------------------
529: -- |---------------------------< delete_validate >----------------------------|
530: -- ----------------------------------------------------------------------------
531: Procedure delete_validate
532: (p_rec in irc_ivc_shd.g_rec_type
533: ) is
534: --
535: l_proc varchar2(72) := g_package||'delete_validate';
536: --