eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_RECRUITMENT_SUMMARY_PKG dependencies on IRC_VAC_MANAGERS

Line 50: delete from irc_vac_managers;

46: delete from irc_vac_summary_details;
47: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY_DETAILS successfully');
48: delete from irc_vac_summary;
49: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY successfully');
50: delete from irc_vac_managers;
51: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');
52: delete from irc_vac_recruiters;
53: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_RECRUITERS successfully');
54: --Insert vacancy_id, manager_id, recruiter_id, organization_id, budget_measurement_value

Line 51: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');

47: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY_DETAILS successfully');
48: delete from irc_vac_summary;
49: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY successfully');
50: delete from irc_vac_managers;
51: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');
52: delete from irc_vac_recruiters;
53: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_RECRUITERS successfully');
54: --Insert vacancy_id, manager_id, recruiter_id, organization_id, budget_measurement_value
55: --into irc_vac_summary table for targetted vacancies

Line 111: --delete all the data from irc_vac_summary_details,irc_vac_recruiters,irc_vac_managers

107: select vacancy_id from per_all_vacancies where status not in ('CLOSED','CLO')
108: and trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate))
109: );
110: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY successfully');
111: --delete all the data from irc_vac_summary_details,irc_vac_recruiters,irc_vac_managers
112: --for vacancies which are not present in irc_vac_summary table
113: delete from irc_vac_summary_details where vacancy_id not in (select vacancy_id from irc_vac_summary);
114: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY_DETAILS successfully');
115: delete from irc_vac_managers where vacancy_id not in (select vacancy_id from irc_vac_summary);

Line 115: delete from irc_vac_managers where vacancy_id not in (select vacancy_id from irc_vac_summary);

111: --delete all the data from irc_vac_summary_details,irc_vac_recruiters,irc_vac_managers
112: --for vacancies which are not present in irc_vac_summary table
113: delete from irc_vac_summary_details where vacancy_id not in (select vacancy_id from irc_vac_summary);
114: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY_DETAILS successfully');
115: delete from irc_vac_managers where vacancy_id not in (select vacancy_id from irc_vac_summary);
116: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');
117: delete from irc_vac_recruiters where vacancy_id not in (select vacancy_id from irc_vac_summary);
118: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_RECRUITERS successfully');
119: --

Line 116: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');

112: --for vacancies which are not present in irc_vac_summary table
113: delete from irc_vac_summary_details where vacancy_id not in (select vacancy_id from irc_vac_summary);
114: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY_DETAILS successfully');
115: delete from irc_vac_managers where vacancy_id not in (select vacancy_id from irc_vac_summary);
116: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');
117: delete from irc_vac_recruiters where vacancy_id not in (select vacancy_id from irc_vac_summary);
118: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_RECRUITERS successfully');
119: --
120: log('Leaving procedure INIT_INCREMENTAL_REFRESH');

Line 324: --populate irc_vac_managers

320: begin
321: --
322: log('Entering procedure REFRESH_MGR_REC');
323: --
324: --populate irc_vac_managers
325: open mgr_cursor;
326: loop
327: fetch mgr_cursor into l_person_id;
328: exit when mgr_cursor%notfound;

Line 329: insert into irc_vac_managers(vacancy_id,manager_id)

325: open mgr_cursor;
326: loop
327: fetch mgr_cursor into l_person_id;
328: exit when mgr_cursor%notfound;
329: insert into irc_vac_managers(vacancy_id,manager_id)
330: select distinct vac.vacancy_id,mgr.manager_id
331: from
332: (select vacancy_id from irc_vac_summary where manager_id=l_person_id and
333: rowid between p_start_rowid and p_end_rowid) vac,

Line 365: log('Populated IRC_VAC_MANAGERS table');

361: end loop;
362: --
363: close mgr_cursor;
364: --
365: log('Populated IRC_VAC_MANAGERS table');
366: --populate irc_vac_recruiters
367: open rec_cursor;
368: loop
369: fetch rec_cursor into l_person_id;

Line 699: delete from irc_vac_managers where vacancy_id in

695: --Do a full_refresh of manager and recruiter hierarchies
696: --This is required to handle any hierarchical changes for
697: --employees like terminations,manager-reassignments etc.
698: --
699: delete from irc_vac_managers where vacancy_id in
700: (select vacancy_id from irc_vac_summary where rowid between p_start_rowid and p_end_rowid);
701: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');
702: --
703: delete from irc_vac_recruiters where vacancy_id in

Line 701: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');

697: --employees like terminations,manager-reassignments etc.
698: --
699: delete from irc_vac_managers where vacancy_id in
700: (select vacancy_id from irc_vac_summary where rowid between p_start_rowid and p_end_rowid);
701: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_MANAGERS successfully');
702: --
703: delete from irc_vac_recruiters where vacancy_id in
704: (select vacancy_id from irc_vac_summary where rowid between p_start_rowid and p_end_rowid);
705: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_RECRUITERS successfully');

Line 954: --Populate irc_vac_managers and irc_vac_recruiters table

950: WHERE vac.rowid between p_start_rowid and p_end_rowid;
951: --
952: log(SQL%ROWCOUNT||' rows updated in table IRC_VAC_SUMMARY successfully');
953: --
954: --Populate irc_vac_managers and irc_vac_recruiters table
955: --
956: refresh_mgr_rec(p_start_rowid,p_end_rowid);
957: --
958: commit;