APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_INS_INT

Line 39: Added column no_set_day_ind to interface table IGS_PS_LGCY_INS_INT.

35: Who When What
36: sarakshi 12-Jan-2006 bug#4926548, replaced the cursor c_table with the pl-sql table .
37: sommukhe 9-JAN-2006 Bug# 4869737,included call to igs_ge_gen_003.set_org_id.
38: smvk 28-Jul-2004 Bug # 3793580. Allowing the user to import instructors for No Set Day USO.
39: Added column no_set_day_ind to interface table IGS_PS_LGCY_INS_INT.
40: sarakshi 04-May-2004 Enh#3568858,populated columns ovrd_wkld_val_flag, workload_val_code to the unit record type
41: smvk 19-Apr-2004 Bug # 3565536. Picking up multiple unit section grading schemas, Also added order by clause to print the
42: log file information order by interface sequence identifier.
43: sarakshi 16-Feb-2004 Bug#3431844, added owner filter in the cursor c_table and modified its usage accordingly

Line 53: igs_ps_lgcy_ins_int interface table also added few column in the

49: smvk 27-Jun-2003 Enh Bug # 2999888. Added Gen_ref_flag in unit reference code.
50: jbegum 02-June-2003 Enh#2972950
51: For Legacy Enhancements TD:
52: Appropriate changes carried out for the inclusion of
53: igs_ps_lgcy_ins_int interface table also added few column in the
54: unit section table to get imported.
55: For PSP Scheduling Enhancements TD:
56: Select preferred_region_code and no_set_day_indicator values from
57: legacy interface table IGS_PS_LGCY_OC_INT into PL/SQL table v_tab_uso.

Line 135: FROM igs_ps_lgcy_ins_int

131: UNION
132: SELECT DISTINCT
133: unit_cd,
134: version_number
135: FROM igs_ps_lgcy_ins_int
136: WHERE batch_id=p_n_batch_id
137: AND import_status IN ('U','R')
138: ORDER BY unit_cd,version_number;
139:

Line 229: CURSOR c_ins ( cp_n_batch_id igs_ps_lgcy_ins_int.batch_id%TYPE ,

225: AND import_status IN ('U','R')
226: ORDER BY unit_cd,version_number, unit_reference_int_id;
227:
228: -- Instructor Interface Table Cursor
229: CURSOR c_ins ( cp_n_batch_id igs_ps_lgcy_ins_int.batch_id%TYPE ,
230: cp_c_unit_cd igs_ps_lgcy_ins_int.unit_cd%TYPE,
231: cp_n_version_number igs_ps_lgcy_ins_int.version_number%TYPE) IS
232: SELECT *
233: FROM igs_ps_lgcy_ins_int

Line 230: cp_c_unit_cd igs_ps_lgcy_ins_int.unit_cd%TYPE,

226: ORDER BY unit_cd,version_number, unit_reference_int_id;
227:
228: -- Instructor Interface Table Cursor
229: CURSOR c_ins ( cp_n_batch_id igs_ps_lgcy_ins_int.batch_id%TYPE ,
230: cp_c_unit_cd igs_ps_lgcy_ins_int.unit_cd%TYPE,
231: cp_n_version_number igs_ps_lgcy_ins_int.version_number%TYPE) IS
232: SELECT *
233: FROM igs_ps_lgcy_ins_int
234: WHERE batch_id=cp_n_batch_id

Line 231: cp_n_version_number igs_ps_lgcy_ins_int.version_number%TYPE) IS

227:
228: -- Instructor Interface Table Cursor
229: CURSOR c_ins ( cp_n_batch_id igs_ps_lgcy_ins_int.batch_id%TYPE ,
230: cp_c_unit_cd igs_ps_lgcy_ins_int.unit_cd%TYPE,
231: cp_n_version_number igs_ps_lgcy_ins_int.version_number%TYPE) IS
232: SELECT *
233: FROM igs_ps_lgcy_ins_int
234: WHERE batch_id=cp_n_batch_id
235: AND unit_cd=cp_c_unit_cd

Line 233: FROM igs_ps_lgcy_ins_int

229: CURSOR c_ins ( cp_n_batch_id igs_ps_lgcy_ins_int.batch_id%TYPE ,
230: cp_c_unit_cd igs_ps_lgcy_ins_int.unit_cd%TYPE,
231: cp_n_version_number igs_ps_lgcy_ins_int.version_number%TYPE) IS
232: SELECT *
233: FROM igs_ps_lgcy_ins_int
234: WHERE batch_id=cp_n_batch_id
235: AND unit_cd=cp_c_unit_cd
236: AND version_number=cp_n_version_number
237: AND import_status IN ('U','R')

Line 439: tablenames_tbl(9) := 'IGS_PS_LGCY_INS_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:
441: FOR i IN 1.. tablenames_tbl.LAST
442: LOOP
443:

Line 1806: UPDATE igs_ps_lgcy_ins_int

1802: IF v_tab_ins(i).status = 'S' AND l_c_return_status = 'S' THEN
1803:
1804: /* Update the interface table */
1805:
1806: UPDATE igs_ps_lgcy_ins_int
1807: SET import_status = 'I'
1808: WHERE batch_id=p_n_batch_id
1809: AND uso_instructor_int_id = v_tab_ins(i).interface_id;
1810:

Line 1841: UPDATE igs_ps_lgcy_ins_int

1837: END IF;
1838:
1839: /* Update the interface table */
1840:
1841: UPDATE igs_ps_lgcy_ins_int
1842: SET import_status = v_tab_ins(i).status
1843: WHERE batch_id=p_n_batch_id
1844: AND uso_instructor_int_id = v_tab_ins(i).interface_id;
1845:

Line 1966: DELETE FROM igs_ps_lgcy_ins_int

1962: AND import_status = 'I';
1963:
1964: /* Delete from Instructor Table */
1965:
1966: DELETE FROM igs_ps_lgcy_ins_int
1967: WHERE batch_id=p_n_batch_id
1968: AND import_status = 'I';
1969:
1970: END If;