APPS.IRC_MRS_UPGRADE dependencies on IRC_ALL_RECRUITING_SITES

Line 14: l_internal_site_id irc_all_recruiting_sites.recruiting_site_id%type;

10: p_end_pkid IN number,
11: p_rows_processed OUT nocopy number)
12: is
13: --
14: l_internal_site_id irc_all_recruiting_sites.recruiting_site_id%type;
15: l_external_site_id irc_all_recruiting_sites.recruiting_site_id%type;
16: l_api_ovn per_recruitment_activities.object_version_number%type;
17: l_int_ext_rec_id per_recruitment_activities.recruitment_activity_id%type;
18: l_third_rec_id per_recruitment_activities.recruitment_activity_id%type;

Line 15: l_external_site_id irc_all_recruiting_sites.recruiting_site_id%type;

11: p_rows_processed OUT nocopy number)
12: is
13: --
14: l_internal_site_id irc_all_recruiting_sites.recruiting_site_id%type;
15: l_external_site_id irc_all_recruiting_sites.recruiting_site_id%type;
16: l_api_ovn per_recruitment_activities.object_version_number%type;
17: l_int_ext_rec_id per_recruitment_activities.recruitment_activity_id%type;
18: l_third_rec_id per_recruitment_activities.recruitment_activity_id%type;
19: l_rec_activity_for_id per_recruitment_activity_for.recruitment_activity_for_id%type;

Line 74: from irc_all_recruiting_sites irs

70: -- This cursor looks for the internal recruiting_site_id
71: --
72: cursor csr_internal is
73: select irs.recruiting_site_id recruiting_site_id
74: from irc_all_recruiting_sites irs
75: where irs.internal = 'Y'
76: and irs.external = 'N';
77: --
78: -- This cursor looks for the external recruiting_site_id

Line 82: from irc_all_recruiting_sites irs

78: -- This cursor looks for the external recruiting_site_id
79: --
80: cursor csr_external is
81: select irs.recruiting_site_id recruiting_site_id
82: from irc_all_recruiting_sites irs
83: where irs.external = 'Y'
84: and irs.internal = 'N';
85: --
86: cursor csr_raa_id is

Line 405: from irc_all_recruiting_sites irs

401: select irs.recruiting_site_id recruiting_site_id
402: ,irs.site_name site_name
403: ,dbms_lob.substr(irs.posting_url) posting_url
404: ,dbms_lob.substr(irs.redirection_url) redirection_url
405: from irc_all_recruiting_sites irs
406: where not exists (select null
407: from irc_all_recruiting_sites_tl itl
408: where itl.recruiting_site_id = irs.recruiting_site_id)
409: and irs.recruiting_site_id between p_start_pkid and p_end_pkid;

Line 407: from irc_all_recruiting_sites_tl itl

403: ,dbms_lob.substr(irs.posting_url) posting_url
404: ,dbms_lob.substr(irs.redirection_url) redirection_url
405: from irc_all_recruiting_sites irs
406: where not exists (select null
407: from irc_all_recruiting_sites_tl itl
408: where itl.recruiting_site_id = irs.recruiting_site_id)
409: and irs.recruiting_site_id between p_start_pkid and p_end_pkid;
410: --
411: cursor csr_lang is

Line 433: update irc_all_recruiting_sites irs

429: end loop;
430: l_rows_processed := l_rows_processed + 1;
431: end loop;
432: --
433: update irc_all_recruiting_sites irs
434: set internal_name=upper(site_name)
435: where internal_name is null
436: and irs.recruiting_site_id between p_start_pkid and p_end_pkid;
437: --