eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_RSE_BUS dependencies on IRC_ALL_RECRUITING_SITES

Line 122: ,p_descflex_name => 'IRC_ALL_RECRUITING_SITES'

118: -- b) During insert.
119: --
120: hr_dflex_utility.ins_or_upd_descflex_attribs
121: (p_appl_short_name => 'PER'
122: ,p_descflex_name => 'IRC_ALL_RECRUITING_SITES'
123: ,p_attribute_category => p_rec.attribute_category
124: ,p_attribute1_name => 'ATTRIBUTE1'
125: ,p_attribute1_value => p_rec.attribute1
126: ,p_attribute2_name => 'ATTRIBUTE2'

Line 267: (p_internal in irc_all_recruiting_sites.internal%TYPE

263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure chk_internal
267: (p_internal in irc_all_recruiting_sites.internal%TYPE
268: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
269: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
270: ) IS
271: --

Line 268: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure chk_internal
267: (p_internal in irc_all_recruiting_sites.internal%TYPE
268: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
269: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
270: ) IS
271: --
272: l_proc varchar2(72) := g_package || 'chk_internal';

Line 269: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

265: -- ----------------------------------------------------------------------------
266: Procedure chk_internal
267: (p_internal in irc_all_recruiting_sites.internal%TYPE
268: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
269: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
270: ) IS
271: --
272: l_proc varchar2(72) := g_package || 'chk_internal';
273: l_api_updating boolean;

Line 300: 'IRC_ALL_RECRUITING_SITES.INTERNAL'

296: exception
297: when app_exception.application_exception then
298: if hr_multi_message.exception_add
299: (p_associated_column1 =>
300: 'IRC_ALL_RECRUITING_SITES.INTERNAL'
301: ) then
302: hr_utility.set_location(' Leaving:'||l_proc,60);
303: raise;
304: end if;

Line 334: (p_external in irc_all_recruiting_sites.external%TYPE

330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure chk_external
334: (p_external in irc_all_recruiting_sites.external%TYPE
335: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
336: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
337: ) IS
338: --

Line 335: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure chk_external
334: (p_external in irc_all_recruiting_sites.external%TYPE
335: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
336: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
337: ) IS
338: --
339: l_proc varchar2(72) := g_package || 'chk_external';

Line 336: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

332: -- ----------------------------------------------------------------------------
333: Procedure chk_external
334: (p_external in irc_all_recruiting_sites.external%TYPE
335: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
336: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
337: ) IS
338: --
339: l_proc varchar2(72) := g_package || 'chk_external';
340: l_api_updating boolean;

Line 367: 'IRC_ALL_RECRUITING_SITES.EXTERNAL'

363: exception
364: when app_exception.application_exception then
365: if hr_multi_message.exception_add
366: (p_associated_column1 =>
367: 'IRC_ALL_RECRUITING_SITES.EXTERNAL'
368: ) then
369: hr_utility.set_location(' Leaving:'||l_proc,60);
370: raise;
371: end if;

Line 401: (p_third_party in irc_all_recruiting_sites.third_party%TYPE

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure chk_third_party
401: (p_third_party in irc_all_recruiting_sites.third_party%TYPE
402: ,p_internal in irc_all_recruiting_sites.internal%TYPE
403: ,p_external in irc_all_recruiting_sites.external%TYPE
404: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
405: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

Line 402: ,p_internal in irc_all_recruiting_sites.internal%TYPE

398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure chk_third_party
401: (p_third_party in irc_all_recruiting_sites.third_party%TYPE
402: ,p_internal in irc_all_recruiting_sites.internal%TYPE
403: ,p_external in irc_all_recruiting_sites.external%TYPE
404: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
405: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
406: ) IS

Line 403: ,p_external in irc_all_recruiting_sites.external%TYPE

399: -- ----------------------------------------------------------------------------
400: Procedure chk_third_party
401: (p_third_party in irc_all_recruiting_sites.third_party%TYPE
402: ,p_internal in irc_all_recruiting_sites.internal%TYPE
403: ,p_external in irc_all_recruiting_sites.external%TYPE
404: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
405: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
406: ) IS
407: --

Line 404: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

400: Procedure chk_third_party
401: (p_third_party in irc_all_recruiting_sites.third_party%TYPE
402: ,p_internal in irc_all_recruiting_sites.internal%TYPE
403: ,p_external in irc_all_recruiting_sites.external%TYPE
404: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
405: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
406: ) IS
407: --
408: l_proc varchar2(72) := g_package || 'chk_third_party';

Line 405: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

401: (p_third_party in irc_all_recruiting_sites.third_party%TYPE
402: ,p_internal in irc_all_recruiting_sites.internal%TYPE
403: ,p_external in irc_all_recruiting_sites.external%TYPE
404: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
405: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
406: ) IS
407: --
408: l_proc varchar2(72) := g_package || 'chk_third_party';
409: l_api_updating boolean;

Line 444: 'IRC_ALL_RECRUITING_SITES.THIRD_PARTY'

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

Line 480: p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE

476: --
477: -- {End Of Comments}
478: Procedure chk_posting_cost_period
479: (
480: p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
481: ,p_effective_date in date
482: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
483: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
484: )

Line 482: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

478: Procedure chk_posting_cost_period
479: (
480: p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
481: ,p_effective_date in date
482: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
483: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
484: )
485: is
486: --

Line 483: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

479: (
480: p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
481: ,p_effective_date in date
482: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
483: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
484: )
485: is
486: --
487: l_proc varchar2(72):=g_package||'chk_posting_cost_period';

Line 541: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'

537: exception
538: when app_exception.application_exception then
539: if hr_multi_message.exception_add
540: (p_associated_column1 =>
541: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'
542: ) then
543: hr_utility.set_location(' Leaving:'||l_proc,80);
544: raise;
545: end if;

Line 580: p_posting_cost in irc_all_recruiting_sites.posting_cost%TYPE

576: --
577: -- {End Of Comments}
578: Procedure chk_posting_cost
579: (
580: p_posting_cost in irc_all_recruiting_sites.posting_cost%TYPE
581: ,p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
582: ,p_posting_cost_currency in irc_all_recruiting_sites.posting_cost_currency%TYPE
583: ,p_effective_date in date
584: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

Line 581: ,p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE

577: -- {End Of Comments}
578: Procedure chk_posting_cost
579: (
580: p_posting_cost in irc_all_recruiting_sites.posting_cost%TYPE
581: ,p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
582: ,p_posting_cost_currency in irc_all_recruiting_sites.posting_cost_currency%TYPE
583: ,p_effective_date in date
584: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
585: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

Line 582: ,p_posting_cost_currency in irc_all_recruiting_sites.posting_cost_currency%TYPE

578: Procedure chk_posting_cost
579: (
580: p_posting_cost in irc_all_recruiting_sites.posting_cost%TYPE
581: ,p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
582: ,p_posting_cost_currency in irc_all_recruiting_sites.posting_cost_currency%TYPE
583: ,p_effective_date in date
584: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
585: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
586: )

Line 584: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

580: p_posting_cost in irc_all_recruiting_sites.posting_cost%TYPE
581: ,p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
582: ,p_posting_cost_currency in irc_all_recruiting_sites.posting_cost_currency%TYPE
583: ,p_effective_date in date
584: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
585: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
586: )
587: is
588: --

Line 585: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

581: ,p_posting_cost_period in irc_all_recruiting_sites.posting_cost_period%TYPE
582: ,p_posting_cost_currency in irc_all_recruiting_sites.posting_cost_currency%TYPE
583: ,p_effective_date in date
584: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
585: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
586: )
587: is
588: --
589: l_proc varchar2(72):=g_package||'chk_posting_cost';

Line 592: l_posting_cost irc_all_recruiting_sites.posting_cost%TYPE;

588: --
589: l_proc varchar2(72):=g_package||'chk_posting_cost';
590: l_api_updating boolean;
591: --
592: l_posting_cost irc_all_recruiting_sites.posting_cost%TYPE;
593: l_posting_cost_period irc_all_recruiting_sites.posting_cost_period%TYPE;
594: l_posting_cost_currency irc_all_recruiting_sites.posting_cost_currency%TYPE;
595: begin
596: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 593: l_posting_cost_period irc_all_recruiting_sites.posting_cost_period%TYPE;

589: l_proc varchar2(72):=g_package||'chk_posting_cost';
590: l_api_updating boolean;
591: --
592: l_posting_cost irc_all_recruiting_sites.posting_cost%TYPE;
593: l_posting_cost_period irc_all_recruiting_sites.posting_cost_period%TYPE;
594: l_posting_cost_currency irc_all_recruiting_sites.posting_cost_currency%TYPE;
595: begin
596: hr_utility.set_location('Entering:'|| l_proc, 1);
597: --

Line 594: l_posting_cost_currency irc_all_recruiting_sites.posting_cost_currency%TYPE;

590: l_api_updating boolean;
591: --
592: l_posting_cost irc_all_recruiting_sites.posting_cost%TYPE;
593: l_posting_cost_period irc_all_recruiting_sites.posting_cost_period%TYPE;
594: l_posting_cost_currency irc_all_recruiting_sites.posting_cost_currency%TYPE;
595: begin
596: hr_utility.set_location('Entering:'|| l_proc, 1);
597: --
598: -- Check mandatory parameters have been set

Line 688: 'IRC_ALL_RECRUITING_SITES.POSTING_COST'

684: when app_exception.application_exception then
685: hr_utility.set_location('exception handler'||l_proc, 90);
686: if hr_multi_message.exception_add
687: (p_associated_column1 =>
688: 'IRC_ALL_RECRUITING_SITES.POSTING_COST'
689: ,p_associated_column2 =>
690: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'
691: ,p_associated_column3 =>
692: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_CURRENCY'

Line 690: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'

686: if hr_multi_message.exception_add
687: (p_associated_column1 =>
688: 'IRC_ALL_RECRUITING_SITES.POSTING_COST'
689: ,p_associated_column2 =>
690: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'
691: ,p_associated_column3 =>
692: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_CURRENCY'
693: ) then
694: hr_utility.set_location(' Leaving:'||l_proc,90);

Line 692: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_CURRENCY'

688: 'IRC_ALL_RECRUITING_SITES.POSTING_COST'
689: ,p_associated_column2 =>
690: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_PERIOD'
691: ,p_associated_column3 =>
692: 'IRC_ALL_RECRUITING_SITES.POSTING_COST_CURRENCY'
693: ) then
694: hr_utility.set_location(' Leaving:'||l_proc,90);
695: raise;
696: end if;

Line 726: (p_date_from in irc_all_recruiting_sites.date_from%TYPE

722: -- Access Status:
723: -- Internal Table Handler Use Only.
724: --
725: Procedure chk_date_from_to
726: (p_date_from in irc_all_recruiting_sites.date_from%TYPE
727: ,p_date_to in irc_all_recruiting_sites.date_to%TYPE
728: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
729: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
730: )

Line 727: ,p_date_to in irc_all_recruiting_sites.date_to%TYPE

723: -- Internal Table Handler Use Only.
724: --
725: Procedure chk_date_from_to
726: (p_date_from in irc_all_recruiting_sites.date_from%TYPE
727: ,p_date_to in irc_all_recruiting_sites.date_to%TYPE
728: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
729: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
730: )
731: is

Line 728: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE

724: --
725: Procedure chk_date_from_to
726: (p_date_from in irc_all_recruiting_sites.date_from%TYPE
727: ,p_date_to in irc_all_recruiting_sites.date_to%TYPE
728: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
729: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
730: )
731: is
732: --

Line 729: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE

725: Procedure chk_date_from_to
726: (p_date_from in irc_all_recruiting_sites.date_from%TYPE
727: ,p_date_to in irc_all_recruiting_sites.date_to%TYPE
728: ,p_recruiting_site_id in irc_all_recruiting_sites.recruiting_site_id%TYPE
729: ,p_object_version_number in irc_all_recruiting_sites.object_version_number%TYPE
730: )
731: is
732: --
733: l_proc varchar2(72):=g_package||'chk_date_from_to';

Line 780: 'IRC_ALL_RECRUITING_SITES.DATE_FROM'

776: exception
777: when app_exception.application_exception then
778: if hr_multi_message.exception_add
779: (p_associated_column1 =>
780: 'IRC_ALL_RECRUITING_SITES.DATE_FROM'
781: ,p_associated_column2 =>
782: 'IRC_ALL_RECRUITING_SITES.DATE_TO'
783: ) then
784: hr_utility.set_location(' Leaving:'||l_proc,80);

Line 782: 'IRC_ALL_RECRUITING_SITES.DATE_TO'

778: if hr_multi_message.exception_add
779: (p_associated_column1 =>
780: 'IRC_ALL_RECRUITING_SITES.DATE_FROM'
781: ,p_associated_column2 =>
782: 'IRC_ALL_RECRUITING_SITES.DATE_TO'
783: ) then
784: hr_utility.set_location(' Leaving:'||l_proc,80);
785: raise;
786: end if;