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.HRI_OPL_JOB_JOB_ROLE dependencies on HRI_CS_JOB_JOB_ROLE_CT

Line 68: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_hri_schema || '.HRI_CS_JOB_JOB_ROLE_CT';

64: -- Truncate the table
65: --
66: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, g_hri_schema)) THEN
67: --
68: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_hri_schema || '.HRI_CS_JOB_JOB_ROLE_CT';
69: --
70: END IF;
71: --
72: dbg('Inserting into hri_cs_job_job_role_ct.');

Line 72: dbg('Inserting into hri_cs_job_job_role_ct.');

68: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_hri_schema || '.HRI_CS_JOB_JOB_ROLE_CT';
69: --
70: END IF;
71: --
72: dbg('Inserting into hri_cs_job_job_role_ct.');
73: --
74: INSERT INTO HRI_CS_JOB_JOB_ROLE_CT
75: (job_id
76: ,job_role_code

Line 74: INSERT INTO HRI_CS_JOB_JOB_ROLE_CT

70: END IF;
71: --
72: dbg('Inserting into hri_cs_job_job_role_ct.');
73: --
74: INSERT INTO HRI_CS_JOB_JOB_ROLE_CT
75: (job_id
76: ,job_role_code
77: ,primary_role_for_job_flag
78: ,created_by

Line 130: TYPE l_number_tab_type IS TABLE OF hri_cs_job_job_role_ct.job_id%TYPE;

126: l_end_date DATE := SYSDATE;
127: --
128: -- PL/SQL table of updated job records
129: --
130: TYPE l_number_tab_type IS TABLE OF hri_cs_job_job_role_ct.job_id%TYPE;
131: l_upd_job_ids L_NUMBER_TAB_TYPE;
132: --
133: BEGIN
134: --

Line 139: dbg('Incrementaly inserting into hri_cs_job_job_role_ct.');

135: output('Incremetally refreshing the Job Role table.');
136: --
137: -- Insert the new job ids and the corresponding job roles
138: --
139: dbg('Incrementaly inserting into hri_cs_job_job_role_ct.');
140: --
141: INSERT INTO hri_cs_job_job_role_ct
142: (job_id
143: ,job_role_code

Line 141: INSERT INTO hri_cs_job_job_role_ct

137: -- Insert the new job ids and the corresponding job roles
138: --
139: dbg('Incrementaly inserting into hri_cs_job_job_role_ct.');
140: --
141: INSERT INTO hri_cs_job_job_role_ct
142: (job_id
143: ,job_role_code
144: ,primary_role_for_job_flag
145: ,created_by

Line 171: FROM hri_cs_job_job_role_ct jbrl

167: ,l_user_id
168: FROM hri_cs_job_job_role_v jbrlv
169: WHERE NOT EXISTS
170: (SELECT null
171: FROM hri_cs_job_job_role_ct jbrl
172: WHERE jbrlv.job_id = jbrl.job_id);
173: --
174: -- Delete the non - existant job ids
175: --

Line 178: dbg('Incrementaly deleting from hri_cs_job_job_role_ct.');

174: -- Delete the non - existant job ids
175: --
176: dbg('Inserted '||sql%rowcount||' records.');
177: --
178: dbg('Incrementaly deleting from hri_cs_job_job_role_ct.');
179: --
180: DELETE FROM hri_cs_job_job_role_ct jbrl
181: WHERE NOT EXISTS
182: (SELECT null

Line 180: DELETE FROM hri_cs_job_job_role_ct jbrl

176: dbg('Inserted '||sql%rowcount||' records.');
177: --
178: dbg('Incrementaly deleting from hri_cs_job_job_role_ct.');
179: --
180: DELETE FROM hri_cs_job_job_role_ct jbrl
181: WHERE NOT EXISTS
182: (SELECT null
183: FROM hri_cs_job_job_role_v jbrlv
184: WHERE jbrlv.job_id = jbrl.job_id);

Line 190: dbg('Incrementaly updating hri_cs_job_job_role_ct.');

186: dbg('Deleted '||sql%rowcount||' records.');
187: --
188: -- Update the records for which there was a change in job family/job function
189: --
190: dbg('Incrementaly updating hri_cs_job_job_role_ct.');
191: --
192: UPDATE hri_cs_job_job_role_ct jbrl
193: SET (jbrl.job_role_code
194: ,primary_role_for_job_flag) =

Line 192: UPDATE hri_cs_job_job_role_ct jbrl

188: -- Update the records for which there was a change in job family/job function
189: --
190: dbg('Incrementaly updating hri_cs_job_job_role_ct.');
191: --
192: UPDATE hri_cs_job_job_role_ct jbrl
193: SET (jbrl.job_role_code
194: ,primary_role_for_job_flag) =
195: (SELECT
196: jbrlv.job_role_code