DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on PER_ALL_PEOPLE_F

Line 9: , party_id per_all_people_f.party_id%type

5: -- RECORD AND TABLE STRUCTURES
6: -- ----------------------------------------------------------------------------
7: TYPE g_seeker_rec_type
8: IS RECORD ( person_id irc_notification_preferences.person_id%TYPE
9: , party_id per_all_people_f.party_id%type
10: , show_jobs_since NUMBER
11: , lang_pref varchar2(100)
12: );
13: TYPE g_seeker_criteria_rec_type

Line 16: , party_id per_all_people_f.party_id%type

12: );
13: TYPE g_seeker_criteria_rec_type
14: IS RECORD ( search_criteria_id irc_search_criteria.search_criteria_id%TYPE
15: , person_id irc_search_criteria.object_id%TYPE
16: , party_id per_all_people_f.party_id%type
17: , distance_to_location irc_search_criteria.distance_to_location%TYPE
18: , location irc_search_criteria.location%TYPE
19: , employee irc_search_criteria.employee%TYPE
20: , contractor irc_search_criteria.contractor%TYPE

Line 200: IS RECORD ( full_name per_all_people_f.full_name%TYPE

196: g_posting_details_rec_type
197: INDEX BY BINARY_INTEGER;
198:
199: TYPE g_seeker_details_rec_type
200: IS RECORD ( full_name per_all_people_f.full_name%TYPE
201: , person_id per_all_people_f.person_id%TYPE
202: );
203: TYPE g_seeker_details_tab_type
204: IS TABLE OF

Line 201: , person_id per_all_people_f.person_id%TYPE

197: INDEX BY BINARY_INTEGER;
198:
199: TYPE g_seeker_details_rec_type
200: IS RECORD ( full_name per_all_people_f.full_name%TYPE
201: , person_id per_all_people_f.person_id%TYPE
202: );
203: TYPE g_seeker_details_tab_type
204: IS TABLE OF
205: g_seeker_details_rec_type