eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_SH_USEC_OCCURS

Line 1769: FROM IGS_PS_SH_USEC_OCCURS

1765: l_cur_occur cur_occur%ROWTYPE;
1766:
1767: CURSOR c_shadow_num(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1768: SELECT count(*)
1769: FROM IGS_PS_SH_USEC_OCCURS
1770: WHERE unit_section_occurrence_id= l_unit_sec_occurrence_id;
1771: l_shadow_num number;
1772: l_new_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1773: l_new_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';

Line 1797: l_new_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;

1793: l_old_building_code VARCHAR2(10):='1';
1794: l_old_room_code VARCHAR2(10):='1';
1795:
1796: i binary_integer:=1;ctr number;
1797: l_new_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;
1798: l_old_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;
1799: l_new_usecsh_id IGS_PS_SH_USEC_OCCURS.usecsh_id%TYPE;
1800: l_new_unit_section_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE;
1801:

Line 1798: l_old_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;

1794: l_old_room_code VARCHAR2(10):='1';
1795:
1796: i binary_integer:=1;ctr number;
1797: l_new_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;
1798: l_old_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;
1799: l_new_usecsh_id IGS_PS_SH_USEC_OCCURS.usecsh_id%TYPE;
1800: l_new_unit_section_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE;
1801:
1802: CURSOR c_shadow_rec(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS

Line 1799: l_new_usecsh_id IGS_PS_SH_USEC_OCCURS.usecsh_id%TYPE;

1795:
1796: i binary_integer:=1;ctr number;
1797: l_new_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;
1798: l_old_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE := NULL;
1799: l_new_usecsh_id IGS_PS_SH_USEC_OCCURS.usecsh_id%TYPE;
1800: l_new_unit_section_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE;
1801:
1802: CURSOR c_shadow_rec(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1803: SELECT monday,tuesday, wednesday, thursday, friday, saturday,

Line 1805: FROM IGS_PS_SH_USEC_OCCURS

1801:
1802: CURSOR c_shadow_rec(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1803: SELECT monday,tuesday, wednesday, thursday, friday, saturday,
1804: sunday, start_time, end_time, building_code, room_code, instructor_id
1805: FROM IGS_PS_SH_USEC_OCCURS
1806: WHERE unit_section_occurrence_id= l_unit_sec_occurrence_id;
1807:
1808: l_shd_monday IGS_PS_USEC_OCCURS_V.monday%TYPE:= '1';
1809: l_shd_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE:= '1';

Line 1819: l_shd_instructor_id IGS_PS_SH_USEC_OCCURS_V.instructor_id%TYPE:= '1';

1815: l_shd_start_time VARCHAR2(50):='1';
1816: l_shd_end_time VARCHAR2(50):='1';
1817: l_shd_building_code VARCHAR2(10):='1';
1818: l_shd_room_code VARCHAR2(10):='1';
1819: l_shd_instructor_id IGS_PS_SH_USEC_OCCURS_V.instructor_id%TYPE:= '1';
1820: lv_usec_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE:= 1;
1821: CURSOR c_insv_unit_sec_occur_id(l_unit_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1822: SELECT instructor_id from IGS_PS_SH_USEC_OCCURS
1823: WHERE unit_section_occurrence_id =l_unit_occur_id;

Line 1822: SELECT instructor_id from IGS_PS_SH_USEC_OCCURS

1818: l_shd_room_code VARCHAR2(10):='1';
1819: l_shd_instructor_id IGS_PS_SH_USEC_OCCURS_V.instructor_id%TYPE:= '1';
1820: lv_usec_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE:= 1;
1821: CURSOR c_insv_unit_sec_occur_id(l_unit_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1822: SELECT instructor_id from IGS_PS_SH_USEC_OCCURS
1823: WHERE unit_section_occurrence_id =l_unit_occur_id;
1824: l_insv_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE;
1825:
1826: CURSOR cur_sch_int(cp_uso_id IN NUMBER) IS

Line 1824: l_insv_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE;

1820: lv_usec_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE:= 1;
1821: CURSOR c_insv_unit_sec_occur_id(l_unit_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1822: SELECT instructor_id from IGS_PS_SH_USEC_OCCURS
1823: WHERE unit_section_occurrence_id =l_unit_occur_id;
1824: l_insv_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE;
1825:
1826: CURSOR cur_sch_int(cp_uso_id IN NUMBER) IS
1827: SELECT uso.transaction_type,uso.schedule_status,uso.int_occurs_id,uso.int_usec_id,uso.tba_status, usec.int_pat_id
1828: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all usec

Line 2395: SELECT IGS_PS_SH_USEC_OCCURS_S.NEXTVAL INTO l_new_usecsh_id FROM dual;

2391:
2392: l_new_instructor_id := NULL;
2393:
2394:
2395: SELECT IGS_PS_SH_USEC_OCCURS_S.NEXTVAL INTO l_new_usecsh_id FROM dual;
2396: l_new_unit_section_occur_id :=p_n_uso_id;
2397: INSERT INTO IGS_PS_SH_USEC_OCCURS(USECSH_ID,
2398: UNIT_SECTION_OCCURRENCE_ID,
2399: MONDAY,

Line 2397: INSERT INTO IGS_PS_SH_USEC_OCCURS(USECSH_ID,

2393:
2394:
2395: SELECT IGS_PS_SH_USEC_OCCURS_S.NEXTVAL INTO l_new_usecsh_id FROM dual;
2396: l_new_unit_section_occur_id :=p_n_uso_id;
2397: INSERT INTO IGS_PS_SH_USEC_OCCURS(USECSH_ID,
2398: UNIT_SECTION_OCCURRENCE_ID,
2399: MONDAY,
2400: TUESDAY,
2401: WEDNESDAY,

Line 2568: UPDATE IGS_PS_SH_USEC_OCCURS SET

2564: NVL(l_shd_room_code,'X') <> NVL(l_new_room_code,'X') OR
2565: NVL(l_shd_instructor_id ,'X')<> NVL(l_new_instructor_id,'X') THEN
2566:
2567:
2568: UPDATE IGS_PS_SH_USEC_OCCURS SET
2569: monday = l_new_monday,
2570: tuesday = l_new_tuesday,
2571: wednesday = l_new_wednesday,
2572: thursday = l_new_thursday,