APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on HRI_EQ_UTL_ABSNC_DIM

Line 108: INSERT INTO hri_eq_utl_absnc_dim

104: PROCEDURE update_eq_with_status_changes IS
105:
106: BEGIN
107:
108: INSERT INTO hri_eq_utl_absnc_dim
109: (absence_attendance_id)
110: SELECT
111: dim.absence_attendance_id
112: FROM

Line 118: FROM hri_eq_utl_absnc_dim eq

114: WHERE dim.absence_status_code IN ('FUTURE','OCCURRING')
115: AND dim.abs_start_date <= trunc(sysdate)
116: AND NOT EXISTS
117: (SELECT null
118: FROM hri_eq_utl_absnc_dim eq
119: WHERE eq.absence_attendance_id = dim.absence_attendance_id);
120:
121: commit;
122:

Line 145: ,hri_eq_utl_absnc_dim eq

141: SELECT
142: dim.absence_sk_pk
143: FROM
144: hri_cs_absence_ct dim
145: ,hri_eq_utl_absnc_dim eq
146: WHERE dim.absence_attendance_id = eq.absence_attendance_id
147: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
148: AND NOT EXISTS
149: (SELECT null

Line 169: ,hri_eq_utl_absnc_dim eq

165: ,'ABSENCE'
166: ,to_date(null)
167: FROM
168: hri_cs_absence_ct dim
169: ,hri_eq_utl_absnc_dim eq
170: WHERE dim.absence_attendance_id = eq.absence_attendance_id
171: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
172: AND NOT EXISTS
173: (SELECT null

Line 191: ,hri_eq_utl_absnc_dim eq

187: SELECT
188: dim.absence_sk_pk
189: FROM
190: hri_cs_absence_ct dim
191: ,hri_eq_utl_absnc_dim eq
192: WHERE dim.absence_attendance_id = eq.absence_attendance_id
193: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
194: AND NOT EXISTS
195: (SELECT null

Line 210: ,hri_eq_utl_absnc_dim eq

206: ,'ABSENCE'
207: ,to_date(null)
208: FROM
209: hri_cs_absence_ct dim
210: ,hri_eq_utl_absnc_dim eq
211: WHERE dim.absence_attendance_id = eq.absence_attendance_id
212: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
213: AND NOT EXISTS
214: (SELECT null

Line 241: FROM hri_eq_utl_absnc_dim eq

237: -- Delete old records
238: DELETE FROM hri_cs_absence_ct dim
239: WHERE dim.absence_attendance_id IN
240: (SELECT eq.absence_attendance_id
241: FROM hri_eq_utl_absnc_dim eq
242: WHERE eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id);
243:
244: -- Insert new/changed records
245: INSERT INTO hri_cs_absence_ct

Line 316: ,hri_eq_utl_absnc_dim eq

312: per_absence_attendances paa
313: ,per_absence_attendance_types pat
314: ,per_abs_attendance_reasons par
315: ,per_all_assignments_f asg
316: ,hri_eq_utl_absnc_dim eq
317: WHERE eq.absence_attendance_id BETWEEN p_start_abs_id
318: AND p_end_abs_id
319: AND paa.absence_attendance_id = eq.absence_attendance_id
320: AND paa.absence_attendance_type_id = pat.absence_attendance_type_id

Line 733: FROM hri_eq_utl_absnc_dim eq

729: -- Set the SQL statement for the incremental range
730: p_sqlstr :=
731: 'SELECT /*+ PARALLEL(eq, DEFAULT, DEFAULT) */
732: absence_attendance_id object_id
733: FROM hri_eq_utl_absnc_dim eq
734: ORDER BY absence_attendance_id';
735:
736: END IF;
737:

Line 786: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_UTL_ABSNC_DIM';

782: p_table_owner => l_schema);
783: END IF;
784:
785: -- Empty out absence dimension event queue
786: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_UTL_ABSNC_DIM';
787: EXECUTE IMMEDIATE(l_sql_stmt);
788:
789: END post_process;
790:

Line 825: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_eq_utl_absnc_dim';

821: process_range_incr(0, l_end_abs_id);
822: END IF;
823:
824: -- truncate eq
825: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_dummy || '.hri_eq_utl_absnc_dim';
826:
827: END single_thread_process;
828:
829: END hri_opl_utl_absnc_dim;