APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_SG_INT

Line 114: FROM igs_ps_lgcy_sg_int

110: UNION
111: SELECT DISTINCT
112: unit_cd,
113: version_number
114: FROM igs_ps_lgcy_sg_int
115: WHERE batch_id=p_n_batch_id
116: AND import_status IN ('U','R')
117: UNION
118: SELECT DISTINCT

Line 199: FROM igs_ps_lgcy_sg_int

195: -- Unit Section Grading Schema Interface Table cursor
196:
197: CURSOR c_us_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
198: SELECT *
199: FROM igs_ps_lgcy_sg_int
200: WHERE batch_id=p_n_batch_id
201: AND unit_cd=cp_c_unit_cd
202: AND version_number=cp_n_version_number
203: AND import_status IN ('U','R')

Line 436: tablenames_tbl(6) := 'IGS_PS_LGCY_SG_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';
439: tablenames_tbl(9) := 'IGS_PS_LGCY_INS_INT';
440:

Line 1484: UPDATE igs_ps_lgcy_sg_int

1480: IF v_tab_usec_gs(i).status = 'S' AND l_c_return_status = 'S' THEN
1481:
1482: /* Update the interface table */
1483:
1484: UPDATE igs_ps_lgcy_sg_int
1485: SET import_status = 'I'
1486: WHERE batch_id=p_n_batch_id
1487: AND usec_grd_schm_int_id = v_tab_usec_gs(i).interface_id;
1488:

Line 1505: UPDATE igs_ps_lgcy_sg_int

1501: END IF;
1502:
1503: /* Update the interface table */
1504:
1505: UPDATE igs_ps_lgcy_sg_int
1506: SET import_status = v_tab_usec_gs(i).status
1507: WHERE batch_id=p_n_batch_id
1508: AND usec_grd_schm_int_id = v_tab_usec_gs(i).interface_id;
1509:

Line 1948: DELETE FROM igs_ps_lgcy_sg_int

1944: AND import_status = 'I';
1945:
1946: /* Delete from Unit Section Grading Schema Interface Table */
1947:
1948: DELETE FROM igs_ps_lgcy_sg_int
1949: WHERE batch_id=p_n_batch_id
1950: AND import_status = 'I';
1951:
1952: /* Delete from Unit Section Occurrences Interface Table */