APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_UG_INT

Line 100: FROM igs_ps_lgcy_ug_int

96: UNION
97: SELECT DISTINCT
98: unit_cd,
99: unit_version_number
100: FROM igs_ps_lgcy_ug_int
101: WHERE batch_id=p_n_batch_id
102: AND import_status IN ('U','R')
103: UNION
104: SELECT DISTINCT

Line 177: FROM igs_ps_lgcy_ug_int

173: -- Grading Schema Interface Table cursor
174:
175: CURSOR c_grd_sch(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
176: SELECT *
177: FROM igs_ps_lgcy_ug_int
178: WHERE batch_id=p_n_batch_id
179: AND unit_cd=cp_c_unit_cd
180: AND unit_version_number=cp_n_version_number
181: AND import_status IN ('U','R')

Line 434: tablenames_tbl(4) := 'IGS_PS_LGCY_UG_INT';

430: -- Collect statistics of the interface table as per standards. Bug # 2710978
431: tablenames_tbl(1) := 'IGS_PS_LGCY_UV_INT';
432: tablenames_tbl(2) := 'IGS_PS_LGCY_TR_INT';
433: tablenames_tbl(3) := 'IGS_PS_LGCY_UD_INT';
434: tablenames_tbl(4) := 'IGS_PS_LGCY_UG_INT';
435: tablenames_tbl(5) := 'IGS_PS_LGCY_US_INT';
436: tablenames_tbl(6) := 'IGS_PS_LGCY_SG_INT';
437: tablenames_tbl(7) := 'IGS_PS_LGCY_OC_INT';
438: tablenames_tbl(8) := 'IGS_PS_LGCY_UR_INT';

Line 1277: UPDATE igs_ps_lgcy_ug_int

1273: IF v_tab_unit_gs(i).status = 'S' AND l_c_return_status = 'S' THEN
1274:
1275: /* Update the interface table */
1276:
1277: UPDATE igs_ps_lgcy_ug_int
1278: SET import_status = 'I'
1279: WHERE batch_id=p_n_batch_id
1280: AND uv_grd_schm_int_id = v_tab_unit_gs(i).interface_id;
1281:

Line 1298: UPDATE igs_ps_lgcy_ug_int

1294: END IF;
1295:
1296: /* Update the interface table */
1297:
1298: UPDATE igs_ps_lgcy_ug_int
1299: SET import_status = v_tab_unit_gs(i).status
1300: WHERE batch_id=p_n_batch_id
1301: AND uv_grd_schm_int_id = v_tab_unit_gs(i).interface_id;
1302:

Line 1936: DELETE FROM igs_ps_lgcy_ug_int

1932: AND import_status = 'I';
1933:
1934: /* Delete from Grading Schema Interface Table */
1935:
1936: DELETE FROM igs_ps_lgcy_ug_int
1937: WHERE batch_id=p_n_batch_id
1938: AND import_status = 'I';
1939:
1940: /* Delete from Unit Section Interface Table */