APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_UR_INT

Line 59: values from legacy interface table IGS_PS_LGCY_UR_INT into PL/SQL table v_tab_unit_ref.

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.
58: Select unit section occurrence start date/end date and no set day indicator
59: values from legacy interface table IGS_PS_LGCY_UR_INT into PL/SQL table v_tab_unit_ref.
60: smvk 11-Dec-2002 Bug # 2702065. Modified rec_c_unit_sec.version_number,
61: l_unit_ver_rec.contact_hrs_lab and rec_c_unit_sec.unit_cd.
62: smvk 23-Dec-2002 Bug # 2702147. Logging of successful message in the log file and
63: updation of import_status of the record as 'I' only when the

Line 128: FROM igs_ps_lgcy_ur_int

124: UNION
125: SELECT DISTINCT
126: unit_cd,
127: version_number
128: FROM igs_ps_lgcy_ur_int
129: WHERE batch_id=p_n_batch_id
130: AND import_status IN ('U','R')
131: UNION
132: SELECT DISTINCT

Line 221: FROM igs_ps_lgcy_ur_int

217: -- Unit Reference Codes Interface Table cursor
218:
219: CURSOR c_unit_ref_cd(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
220: SELECT *
221: FROM igs_ps_lgcy_ur_int
222: WHERE batch_id=p_n_batch_id
223: AND unit_cd=cp_c_unit_cd
224: AND version_number=cp_n_version_number
225: AND import_status IN ('U','R')

Line 438: tablenames_tbl(8) := 'IGS_PS_LGCY_UR_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:
441: FOR i IN 1.. tablenames_tbl.LAST
442: LOOP

Line 1691: UPDATE igs_ps_lgcy_ur_int

1687: IF v_tab_unit_ref(i).status = 'S' AND l_c_return_status = 'S' THEN
1688:
1689: /* Update the interface table */
1690:
1691: UPDATE igs_ps_lgcy_ur_int
1692: SET import_status = 'I'
1693: WHERE batch_id=p_n_batch_id
1694: AND unit_reference_int_id = v_tab_unit_ref(i).interface_id;
1695:

Line 1712: UPDATE igs_ps_lgcy_ur_int

1708: END IF;
1709:
1710: /* Update the interface table */
1711:
1712: UPDATE igs_ps_lgcy_ur_int
1713: SET import_status = v_tab_unit_ref(i).status
1714: WHERE batch_id=p_n_batch_id
1715: AND unit_reference_int_id = v_tab_unit_ref(i).interface_id;
1716:

Line 1960: DELETE FROM igs_ps_lgcy_ur_int

1956: AND import_status = 'I';
1957:
1958: /* Delete from Unit Reference Codes Table */
1959:
1960: DELETE FROM igs_ps_lgcy_ur_int
1961: WHERE batch_id=p_n_batch_id
1962: AND import_status = 'I';
1963:
1964: /* Delete from Instructor Table */