APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on IRC_OFFERS

Line 65: from irc_offers iof

61: ,ppf.full_name as applicant_name
62: ,iof.created_by as creator_id
63: ,ipc.name as job_posting_title
64: ,ipc.job_title as ipc_job_title
65: from irc_offers iof
66: ,per_all_vacancies vac
67: ,per_jobs_vl job
68: ,per_all_assignments_f asg
69: ,per_all_people_f ppf

Line 98: from irc_offers iof

94: ,ppf.full_name as applicant_name
95: ,ipc.name as job_posting_title
96: ,ipc.job_title as ipc_job_title
97: ,iof.last_updated_by as last_updated
98: from irc_offers iof
99: ,per_all_vacancies vac
100: ,per_jobs_vl job
101: ,per_all_assignments_f asg
102: ,per_all_people_f ppf

Line 138: from irc_offers iof

134: ,iof.expiry_date
135: ,iof.created_by as creator_id
136: ,ipc.name as job_posting_title
137: ,ipc.job_title as ipc_job_title
138: from irc_offers iof
139: ,per_all_vacancies vac
140: ,per_jobs_vl job
141: ,per_all_assignments_f asg
142: ,per_all_people_f ppf

Line 172: from irc_offers iof

168: ,ppf.full_name as applicant_name
169: ,iof.created_by as creator_id
170: ,ipc.name as job_posting_title
171: ,ipc.job_title as ipc_job_title
172: from irc_offers iof
173: ,per_all_vacancies vac
174: ,per_jobs_vl job
175: ,per_all_assignments_f asg
176: ,per_all_people_f ppf

Line 200: from irc_offers iof

196: select vac.name as vacancy_name
197: ,iof.created_by as creator_id
198: ,job.name as job_title
199: ,ppf.full_name as applicant_name
200: from irc_offers iof
201: ,per_all_vacancies vac
202: ,per_jobs_vl job
203: ,per_all_assignments_f asg
204: ,per_all_people_f ppf

Line 226: from irc_offers

222: where usr.user_id = p_user_id;
223: --
224: cursor csr_get_apl_assignment_id (p_offer_id in number) is
225: select applicant_assignment_id
226: from irc_offers
227: where offer_id = p_offer_id;
228: --
229: cursor get_nls_lang (p_dft_lang varchar2) is
230: select NLS_LANGUAGE

Line 1312: irc_offers_api.close_offer

1308: --
1309: END IF;
1310:
1311: --Set the offer status to 'CLOSED' for the expired offers
1312: irc_offers_api.close_offer
1313: ( p_validate => false
1314: ,p_effective_date => trunc(sysdate)
1315: ,p_offer_id => offer_expired_rec.offer_id
1316: ,p_change_reason => 'EXPIRED'

Line 1425: irc_offers iof

1421: --
1422: cursor csr_get_apl_referrer_id (p_offer_id in number) is
1423: select iri.source_person_id
1424: from irc_referral_info iri,
1425: irc_offers iof
1426: where iri.object_id = iof.APPLICANT_ASSIGNMENT_ID
1427: and iri.object_type = 'APPLICATION'
1428: and iof.offer_id = p_offer_id;
1429: --