APPS.IRC_PARTY_PERSON_UTL dependencies on IRC_SEARCH_CRITERIA

Line 83: from irc_search_criteria

79: where party_id is not null
80: and person_id is null
81: union
82: select object_id party_id, object_id person_id
83: from irc_search_criteria
84: where object_type='WORK'
85: union
86: select party_id,person_id
87: from irc_vacancy_considerations

Line 178: select 1 from irc_search_criteria

174: where organization_id=l_business_group_id
175: and ORG_INFORMATION_CONTEXT='BG Recruitment';
176:
177: cursor get_work_prefs(p_person_id number) is
178: select 1 from irc_search_criteria
179: where object_id=p_person_id
180: and object_type='WPREF';
181:
182: cursor get_notification_prefs(p_party_id number) is

Line 547: update irc_search_criteria

543:
544: --
545: -- update the search criteria and work preferences
546: --
547: update irc_search_criteria
548: set object_id=l_person_ids(i)
549: ,object_type='PERSON'
550: where object_type = 'PARTY'
551: and object_id=l_party_ids(i);

Line 555: update irc_search_criteria

551: and object_id=l_party_ids(i);
552: --
553: -- update the search criteria and work preferences
554: --
555: update irc_search_criteria
556: set object_id=l_person_ids(i)
557: ,object_type='WPREF'
558: where object_type = 'WORK'
559: and object_id=l_party_ids(i);

Line 570: insert into irc_search_criteria

566: close get_work_prefs;
567: else
568: close get_work_prefs;
569: -- no work prefernces, so create some
570: insert into irc_search_criteria
571: (search_criteria_id
572: ,object_id
573: ,object_type
574: ,employee

Line 587: (irc_search_criteria_s.nextval

583: ,created_by
584: ,creation_date
585: ,object_version_number)
586: values
587: (irc_search_criteria_s.nextval
588: ,l_person_ids(i)
589: ,'WPREF'
590: ,'Y'
591: ,'Y'