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: );
12: TYPE g_seeker_criteria_rec_type
13: IS RECORD ( search_criteria_id irc_search_criteria.search_criteria_id%TYPE

Line 15: , party_id per_all_people_f.party_id%type

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

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

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

Line 200: , person_id per_all_people_f.person_id%TYPE

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