[Home] [Help]
82: UNION
83: SELECT DISTINCT
84: unit_cd,
85: version_number
86: FROM igs_ps_lgcy_tr_int
87: WHERE batch_id=p_n_batch_id
88: AND import_status IN ('U','R')
89: UNION
90: SELECT DISTINCT
150: -- Teaching Responsibility Interface Table cursor
151:
152: CURSOR c_teach_resp(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
153: SELECT *
154: FROM igs_ps_lgcy_tr_int
155: WHERE batch_id=p_n_batch_id
156: AND unit_cd=cp_c_unit_cd
157: AND version_number=cp_n_version_number
158: AND import_status IN ('U','R')
428: l_b_return := fnd_installation.get_app_info('IGS', l_c_status, l_c_industry, l_c_schema);
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';
1065: IF v_tab_unit_tr(i).status = 'S' AND l_c_return_status = 'S' THEN
1066:
1067: /* Update the interface table */
1068:
1069: UPDATE igs_ps_lgcy_tr_int
1070: SET import_status = 'I'
1071: WHERE batch_id=p_n_batch_id
1072: AND teach_resp_int_id = v_tab_unit_tr(i).interface_id;
1073:
1086: END IF;
1087:
1088: /* Update the interface table */
1089:
1090: UPDATE igs_ps_lgcy_tr_int
1091: SET import_status = v_tab_unit_tr(i).status
1092: WHERE batch_id=p_n_batch_id
1093: AND teach_resp_int_id = v_tab_unit_tr(i).interface_id;
1094:
1920: AND import_status = 'I';
1921:
1922: /* Delete from Teaching Responsibility Interface Table */
1923:
1924: DELETE FROM igs_ps_lgcy_tr_int
1925: WHERE batch_id=p_n_batch_id
1926: AND import_status = 'I';
1927:
1928: /* Delete from Unit Disciplines Interface Table */