APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_OC_INT

Line 57: legacy interface table IGS_PS_LGCY_OC_INT into PL/SQL table v_tab_uso.

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.
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.

Line 121: FROM igs_ps_lgcy_oc_int

117: UNION
118: SELECT DISTINCT
119: unit_cd,
120: version_number
121: FROM igs_ps_lgcy_oc_int
122: WHERE batch_id=p_n_batch_id
123: AND import_status IN ('U','R')
124: UNION
125: SELECT DISTINCT

Line 210: FROM igs_ps_lgcy_oc_int

206: -- Unit Section Occurrences Interface Table cursor
207:
208: CURSOR c_uso(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
209: SELECT *
210: FROM igs_ps_lgcy_oc_int
211: WHERE batch_id=p_n_batch_id
212: AND unit_cd=cp_c_unit_cd
213: AND version_number=cp_n_version_number
214: AND import_status IN ('U','R')

Line 437: tablenames_tbl(7) := 'IGS_PS_LGCY_OC_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';
440:
441: FOR i IN 1.. tablenames_tbl.LAST

Line 1588: UPDATE igs_ps_lgcy_oc_int

1584: IF v_tab_uso(i).status = 'S' AND l_c_return_status = 'S' THEN
1585:
1586: /* Update the interface table */
1587:
1588: UPDATE igs_ps_lgcy_oc_int
1589: SET import_status = 'I'
1590: WHERE batch_id=p_n_batch_id
1591: AND usec_occur_int_id = v_tab_uso(i).interface_id;
1592:

Line 1609: UPDATE igs_ps_lgcy_oc_int

1605: END IF;
1606:
1607: /* Update the interface table */
1608:
1609: UPDATE igs_ps_lgcy_oc_int
1610: SET import_status = v_tab_uso(i).status
1611: WHERE batch_id=p_n_batch_id
1612: AND usec_occur_int_id = v_tab_uso(i).interface_id;
1613:

Line 1954: DELETE FROM igs_ps_lgcy_oc_int

1950: AND import_status = 'I';
1951:
1952: /* Delete from Unit Section Occurrences Interface Table */
1953:
1954: DELETE FROM igs_ps_lgcy_oc_int
1955: WHERE batch_id=p_n_batch_id
1956: AND import_status = 'I';
1957:
1958: /* Delete from Unit Reference Codes Table */