APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_UD_INT

Line 93: FROM igs_ps_lgcy_ud_int

89: UNION
90: SELECT DISTINCT
91: unit_cd,
92: version_number
93: FROM igs_ps_lgcy_ud_int
94: WHERE batch_id=p_n_batch_id
95: AND import_status IN ('U','R')
96: UNION
97: SELECT DISTINCT

Line 165: FROM igs_ps_lgcy_ud_int

161: -- Unit Discplines Interface Table cursor
162:
163: CURSOR c_unit_disp(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
164: SELECT *
165: FROM igs_ps_lgcy_ud_int
166: WHERE batch_id=p_n_batch_id
167: AND unit_cd=cp_c_unit_cd
168: AND version_number=cp_n_version_number
169: AND import_status IN ('U','R')

Line 433: tablenames_tbl(3) := 'IGS_PS_LGCY_UD_INT';

429:
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';

Line 1174: UPDATE igs_ps_lgcy_ud_int

1170: IF v_tab_unit_dscp(i).status = 'S' AND l_c_return_status = 'S' THEN
1171:
1172: /* Update the interface table */
1173:
1174: UPDATE igs_ps_lgcy_ud_int
1175: SET import_status = 'I'
1176: WHERE batch_id=p_n_batch_id
1177: AND unit_discip_int_id = v_tab_unit_dscp(i).interface_id;
1178:

Line 1195: UPDATE igs_ps_lgcy_ud_int

1191: END IF;
1192:
1193: /* Update the interface table */
1194:
1195: UPDATE igs_ps_lgcy_ud_int
1196: SET import_status = v_tab_unit_dscp(i).status
1197: WHERE batch_id=p_n_batch_id
1198: AND unit_discip_int_id = v_tab_unit_dscp(i).interface_id;
1199:

Line 1930: DELETE FROM igs_ps_lgcy_ud_int

1926: AND import_status = 'I';
1927:
1928: /* Delete from Unit Disciplines Interface Table */
1929:
1930: DELETE FROM igs_ps_lgcy_ud_int
1931: WHERE batch_id=p_n_batch_id
1932: AND import_status = 'I';
1933:
1934: /* Delete from Grading Schema Interface Table */