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_INP_BUS dependencies on IRC_NOTIFICATION_PREFERENCES

Line 126: ,p_descflex_name => 'IRC_NOTIFICATION_PREFERENCES'

122: -- b) During insert.
123: --
124: hr_dflex_utility.ins_or_upd_descflex_attribs
125: (p_appl_short_name => 'PER'
126: ,p_descflex_name => 'IRC_NOTIFICATION_PREFERENCES'
127: ,p_attribute_category => p_rec.attribute_category
128: ,p_attribute1_name => 'ATTRIBUTE1'
129: ,p_attribute1_value => p_rec.attribute1
130: ,p_attribute2_name => 'ATTRIBUTE2'

Line 280: (p_person_id in irc_notification_preferences.person_id%type

276: -- Internal Row Handler Use Only.
277: --
278: -- ----------------------------------------------------------------------------
279: Procedure chk_person_id
280: (p_person_id in irc_notification_preferences.person_id%type
281: ,p_party_id in out nocopy irc_notification_preferences.party_id%type
282: ,p_effective_date in date
283: ) is
284: --

Line 281: ,p_party_id in out nocopy irc_notification_preferences.party_id%type

277: --
278: -- ----------------------------------------------------------------------------
279: Procedure chk_person_id
280: (p_person_id in irc_notification_preferences.person_id%type
281: ,p_party_id in out nocopy irc_notification_preferences.party_id%type
282: ,p_effective_date in date
283: ) is
284: --
285: l_proc varchar2(72) := g_package||'chk_person_id';

Line 286: l_party_id irc_notification_preferences.party_id%type;

282: ,p_effective_date in date
283: ) is
284: --
285: l_proc varchar2(72) := g_package||'chk_person_id';
286: l_party_id irc_notification_preferences.party_id%type;
287: cursor l_person is
288: select party_id
289: from per_all_people_f
290: where person_id = p_person_id

Line 326: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'

322: --
323: exception
324: when app_exception.application_exception then
325: if hr_multi_message.exception_add
326: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
327: ) then
328: --
329: hr_utility.set_location(' Leaving:'||l_proc,60);
330: --

Line 365: (p_party_id in irc_notification_preferences.party_id%type

361: -- Internal Row Handler Use Only.
362: --
363: -- ----------------------------------------------------------------------------
364: Procedure chk_party_id
365: (p_party_id in irc_notification_preferences.party_id%type
366: ) is
367: --
368: l_proc varchar2(72) := g_package||'chk_party_id';
369: --

Line 370: l_party_id irc_notification_preferences.party_id%type;

366: ) is
367: --
368: l_proc varchar2(72) := g_package||'chk_party_id';
369: --
370: l_party_id irc_notification_preferences.party_id%type;
371: --
372: l_inp_pk varchar2(1);
373: cursor csr_party_id is
374: select 1

Line 381: from irc_notification_preferences

377: and party_type = 'PERSON';
378: --
379: cursor csr_chk_inp_pk is
380: select null
381: from irc_notification_preferences
382: where party_id = p_party_id;
383: --
384: Begin
385: --

Line 428: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PARTY_ID'

424: --
425: exception
426: when app_exception.application_exception then
427: if hr_multi_message.exception_add
428: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PARTY_ID'
429: ) then
430: --
431: hr_utility.set_location(' Leaving:'||l_proc,60);
432: --

Line 468: in irc_notification_preferences.notification_preference_id%type

464: --
465: -- ----------------------------------------------------------------------------
466: Procedure chk_address_id
467: (p_notification_preference_id
468: in irc_notification_preferences.notification_preference_id%type
469: ,p_address_id
470: in irc_notification_preferences.address_id%type
471: ,p_person_id
472: in irc_notification_preferences.person_id%type

Line 470: in irc_notification_preferences.address_id%type

466: Procedure chk_address_id
467: (p_notification_preference_id
468: in irc_notification_preferences.notification_preference_id%type
469: ,p_address_id
470: in irc_notification_preferences.address_id%type
471: ,p_person_id
472: in irc_notification_preferences.person_id%type
473: ,p_object_version_number
474: in irc_notification_preferences.object_version_number%type

Line 472: in irc_notification_preferences.person_id%type

468: in irc_notification_preferences.notification_preference_id%type
469: ,p_address_id
470: in irc_notification_preferences.address_id%type
471: ,p_person_id
472: in irc_notification_preferences.person_id%type
473: ,p_object_version_number
474: in irc_notification_preferences.object_version_number%type
475: ) is
476: --

Line 474: in irc_notification_preferences.object_version_number%type

470: in irc_notification_preferences.address_id%type
471: ,p_person_id
472: in irc_notification_preferences.person_id%type
473: ,p_object_version_number
474: in irc_notification_preferences.object_version_number%type
475: ) is
476: --
477: l_proc varchar2(72) := g_package||'chk_address_id';
478: --

Line 479: l_address_id irc_notification_preferences.address_id%type;

475: ) is
476: --
477: l_proc varchar2(72) := g_package||'chk_address_id';
478: --
479: l_address_id irc_notification_preferences.address_id%type;
480: --
481: l_api_updating boolean;
482: --
483: cursor csr_address_id is

Line 498: (p_check_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'

494: -- multi message list does not already contain an error with
495: -- person_id
496: --
497: if hr_multi_message.no_exclusive_error
498: (p_check_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
499: ,p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
500: ) then
501: if p_address_id is not null then
502: --

Line 499: ,p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'

495: -- person_id
496: --
497: if hr_multi_message.no_exclusive_error
498: (p_check_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
499: ,p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.PERSON_ID'
500: ) then
501: if p_address_id is not null then
502: --
503: hr_utility.set_location(l_proc,20);

Line 543: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ADDRESS_ID'

539: --
540: exception
541: when app_exception.application_exception then
542: if hr_multi_message.exception_add
543: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ADDRESS_ID'
544: ) then
545: --
546: hr_utility.set_location(' Leaving:'||l_proc,80);
547: --

Line 583: in irc_notification_preferences.matching_jobs%type

579: --
580: -- ----------------------------------------------------------------------------
581: Procedure chk_matching_jobs
582: (p_matching_jobs
583: in irc_notification_preferences.matching_jobs%type
584: ,p_notification_preference_id
585: in irc_notification_preferences.notification_preference_id%type
586: ,p_object_version_number
587: in irc_notification_preferences.object_version_number%type

Line 585: in irc_notification_preferences.notification_preference_id%type

581: Procedure chk_matching_jobs
582: (p_matching_jobs
583: in irc_notification_preferences.matching_jobs%type
584: ,p_notification_preference_id
585: in irc_notification_preferences.notification_preference_id%type
586: ,p_object_version_number
587: in irc_notification_preferences.object_version_number%type
588: ) is
589: --

Line 587: in irc_notification_preferences.object_version_number%type

583: in irc_notification_preferences.matching_jobs%type
584: ,p_notification_preference_id
585: in irc_notification_preferences.notification_preference_id%type
586: ,p_object_version_number
587: in irc_notification_preferences.object_version_number%type
588: ) is
589: --
590: l_proc varchar2(72) := g_package||'chk_matching_jobs';
591: --

Line 628: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.MATCHING_JOBS'

624: --
625: exception
626: when app_exception.application_exception then
627: if hr_multi_message.exception_add
628: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.MATCHING_JOBS'
629: ) then
630: --
631: hr_utility.set_location(' Leaving:'||l_proc,50);
632: --

Line 670: in irc_notification_preferences.matching_job_freq%type

666: --
667: -- ----------------------------------------------------------------------------
668: Procedure chk_matching_job_freq
669: (p_matching_job_freq
670: in irc_notification_preferences.matching_job_freq%type
671: ,p_notification_preference_id
672: in irc_notification_preferences.notification_preference_id%type
673: ,p_effective_date
674: in date

Line 672: in irc_notification_preferences.notification_preference_id%type

668: Procedure chk_matching_job_freq
669: (p_matching_job_freq
670: in irc_notification_preferences.matching_job_freq%type
671: ,p_notification_preference_id
672: in irc_notification_preferences.notification_preference_id%type
673: ,p_effective_date
674: in date
675: ,p_object_version_number
676: in irc_notification_preferences.object_version_number%type

Line 676: in irc_notification_preferences.object_version_number%type

672: in irc_notification_preferences.notification_preference_id%type
673: ,p_effective_date
674: in date
675: ,p_object_version_number
676: in irc_notification_preferences.object_version_number%type
677: ) is
678: --
679: l_proc varchar2(72) := g_package||'chk_matching_job_freq';
680: --

Line 720: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.MATCHING_JOB_FREQ'

716: --
717: exception
718: when app_exception.application_exception then
719: if hr_multi_message.exception_add
720: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.MATCHING_JOB_FREQ'
721: ) then
722: --
723: hr_utility.set_location(' Leaving:'||l_proc,50);
724: --

Line 760: in irc_notification_preferences.receive_info_mail%type

756: --
757: -- ----------------------------------------------------------------------------
758: Procedure chk_receive_info_mail
759: (p_receive_info_mail
760: in irc_notification_preferences.receive_info_mail%type
761: ,p_notification_preference_id
762: in irc_notification_preferences.notification_preference_id%type
763: ,p_object_version_number
764: in irc_notification_preferences.object_version_number%type

Line 762: in irc_notification_preferences.notification_preference_id%type

758: Procedure chk_receive_info_mail
759: (p_receive_info_mail
760: in irc_notification_preferences.receive_info_mail%type
761: ,p_notification_preference_id
762: in irc_notification_preferences.notification_preference_id%type
763: ,p_object_version_number
764: in irc_notification_preferences.object_version_number%type
765: ) is
766: --

Line 764: in irc_notification_preferences.object_version_number%type

760: in irc_notification_preferences.receive_info_mail%type
761: ,p_notification_preference_id
762: in irc_notification_preferences.notification_preference_id%type
763: ,p_object_version_number
764: in irc_notification_preferences.object_version_number%type
765: ) is
766: --
767: l_proc varchar2(72) := g_package||'chk_receive_info_mail';
768: --

Line 805: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.RECEIVE_INFO_MAIL'

801: --
802: exception
803: when app_exception.application_exception then
804: if hr_multi_message.exception_add
805: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.RECEIVE_INFO_MAIL'
806: ) then
807: --
808: hr_utility.set_location(' Leaving:'||l_proc,50);
809: --

Line 845: in irc_notification_preferences.allow_access%type

841: --
842: -- ----------------------------------------------------------------------------
843: Procedure chk_allow_access
844: (p_allow_access
845: in irc_notification_preferences.allow_access%type
846: ,p_notification_preference_id
847: in irc_notification_preferences.notification_preference_id%type
848: ,p_object_version_number
849: in irc_notification_preferences.object_version_number%type

Line 847: in irc_notification_preferences.notification_preference_id%type

843: Procedure chk_allow_access
844: (p_allow_access
845: in irc_notification_preferences.allow_access%type
846: ,p_notification_preference_id
847: in irc_notification_preferences.notification_preference_id%type
848: ,p_object_version_number
849: in irc_notification_preferences.object_version_number%type
850: ) is
851: --

Line 849: in irc_notification_preferences.object_version_number%type

845: in irc_notification_preferences.allow_access%type
846: ,p_notification_preference_id
847: in irc_notification_preferences.notification_preference_id%type
848: ,p_object_version_number
849: in irc_notification_preferences.object_version_number%type
850: ) is
851: --
852: l_proc varchar2(72) := g_package||'chk_allow_access';
853: --

Line 887: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ALLOW_ACCESS'

883: --
884: exception
885: when app_exception.application_exception then
886: if hr_multi_message.exception_add
887: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ALLOW_ACCESS'
888: ) then
889: --
890: hr_utility.set_location(' Leaving:'||l_proc,40);
891: --

Line 927: in irc_notification_preferences.agency_id%type

923: --
924: -- ----------------------------------------------------------------------------
925: Procedure chk_agency_id
926: (p_agency_id
927: in irc_notification_preferences.agency_id%type
928: ) is
929: --
930: l_proc varchar2(72) := g_package||'chk_agency_id';
931: l_agency_id irc_notification_preferences.agency_id%type;

Line 931: l_agency_id irc_notification_preferences.agency_id%type;

927: in irc_notification_preferences.agency_id%type
928: ) is
929: --
930: l_proc varchar2(72) := g_package||'chk_agency_id';
931: l_agency_id irc_notification_preferences.agency_id%type;
932: cursor csr_agency_id is
933: select 1
934: from po_vendors
935: where vendor_id = p_agency_id

Line 962: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.AGENCY_ID'

958: --
959: exception
960: when app_exception.application_exception then
961: if hr_multi_message.exception_add
962: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.AGENCY_ID'
963: ) then
964: --
965: hr_utility.set_location(' Leaving:'||l_proc,60);
966: --

Line 1000: irc_notification_preferences.attempt_id%type

996: --
997: -- ----------------------------------------------------------------------------
998: Procedure chk_attempt_id
999: (p_attempt_id in
1000: irc_notification_preferences.attempt_id%type
1001: ,p_notification_preference_id in
1002: irc_notification_preferences.notification_preference_id%type
1003: ,p_object_version_number in
1004: irc_notification_preferences.object_version_number%type

Line 1002: irc_notification_preferences.notification_preference_id%type

998: Procedure chk_attempt_id
999: (p_attempt_id in
1000: irc_notification_preferences.attempt_id%type
1001: ,p_notification_preference_id in
1002: irc_notification_preferences.notification_preference_id%type
1003: ,p_object_version_number in
1004: irc_notification_preferences.object_version_number%type
1005: ) is
1006: --

Line 1004: irc_notification_preferences.object_version_number%type

1000: irc_notification_preferences.attempt_id%type
1001: ,p_notification_preference_id in
1002: irc_notification_preferences.notification_preference_id%type
1003: ,p_object_version_number in
1004: irc_notification_preferences.object_version_number%type
1005: ) is
1006: --
1007: l_proc varchar2(72) := g_package||'chk_attempt_id';
1008: l_attempt_exists number;

Line 1062: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ATTEMPT_ID'

1058: --
1059: exception
1060: when app_exception.application_exception then
1061: if hr_multi_message.exception_add
1062: (p_associated_column1 => 'IRC_NOTIFICATION_PREFERENCES.ATTEMPT_ID'
1063: ) then
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc,70);
1066: --