[Home] [Help]
103: UNION
104: SELECT DISTINCT
105: unit_cd,
106: version_number
107: FROM igs_ps_lgcy_us_int
108: WHERE batch_id=p_n_batch_id
109: AND import_status IN ('U','R')
110: UNION
111: SELECT DISTINCT
184: -- Unit Section Interface Table cursor
185:
186: CURSOR c_unit_sec(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
187: SELECT *
188: FROM igs_ps_lgcy_us_int
189: WHERE batch_id=p_n_batch_id
190: AND unit_cd=cp_c_unit_cd
191: AND version_number=cp_n_version_number
192: AND import_status IN ('U','R')
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';
439: tablenames_tbl(9) := 'IGS_PS_LGCY_INS_INT';
1376: IF v_tab_usec(i).status = 'S' AND l_c_return_status = 'S' THEN
1377:
1378: /* Update the interface table */
1379:
1380: UPDATE igs_ps_lgcy_us_int
1381: SET import_status = 'I'
1382: WHERE batch_id=p_n_batch_id
1383: AND unit_section_int_id = v_tab_usec(i).interface_id;
1384:
1397: END IF;
1398:
1399: /* Update the interface table */
1400:
1401: UPDATE igs_ps_lgcy_us_int
1402: SET import_status = v_tab_usec(i).status
1403: WHERE batch_id=p_n_batch_id
1404: AND unit_section_int_id = v_tab_usec(i).interface_id;
1405:
1938: AND import_status = 'I';
1939:
1940: /* Delete from Unit Section Interface Table */
1941:
1942: DELETE FROM igs_ps_lgcy_us_int
1943: WHERE batch_id=p_n_batch_id
1944: AND import_status = 'I';
1945:
1946: /* Delete from Unit Section Grading Schema Interface Table */