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_USEC_OCCURS

Line 54: CURSOR c_usec_occurs ( p_uoo_id IN NUMBER, cp_c_schd_stat IN igs_ps_usec_occurs.schedule_status%TYPE) IS

50:
51: PROCEDURE upd_usec_occurs_schd_status ( p_uoo_id IN NUMBER, schd_stat IN VARCHAR2 ) AS
52:
53: --Bug # 2831065. Update the USO which are not in schedule status processing and input schedule status schd_stat.
54: CURSOR c_usec_occurs ( p_uoo_id IN NUMBER, cp_c_schd_stat IN igs_ps_usec_occurs.schedule_status%TYPE) IS
55: SELECT ROWID, puo.*
56: FROM igs_ps_usec_occurs puo
57: WHERE uoo_id = p_uoo_id
58: AND (schedule_status IS NULL OR schedule_status <> cp_c_schd_stat)

Line 56: FROM igs_ps_usec_occurs puo

52:
53: --Bug # 2831065. Update the USO which are not in schedule status processing and input schedule status schd_stat.
54: CURSOR c_usec_occurs ( p_uoo_id IN NUMBER, cp_c_schd_stat IN igs_ps_usec_occurs.schedule_status%TYPE) IS
55: SELECT ROWID, puo.*
56: FROM igs_ps_usec_occurs puo
57: WHERE uoo_id = p_uoo_id
58: AND (schedule_status IS NULL OR schedule_status <> cp_c_schd_stat)
59: AND NO_SET_DAY_IND ='N'
60: FOR UPDATE NOWAIT;

Line 62: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;

58: AND (schedule_status IS NULL OR schedule_status <> cp_c_schd_stat)
59: AND NO_SET_DAY_IND ='N'
60: FOR UPDATE NOWAIT;
61:
62: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;
63: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
64:
65: BEGIN
66:

Line 63: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;

59: AND NO_SET_DAY_IND ='N'
60: FOR UPDATE NOWAIT;
61:
62: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;
63: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
64:
65: BEGIN
66:
67: FOR c_usec_occurs_rec IN c_usec_occurs(p_uoo_id, schd_stat) LOOP

Line 83: igs_ps_usec_occurs_pkg.update_row (

79: END IF;
80:
81: IF schd_stat ='USER_CANCEL' OR (schd_stat ='USER_UPDATE' AND (c_usec_occurs_rec.schedule_status IS NOT NULL AND c_usec_occurs_rec.schedule_status <> 'PROCESSING')) THEN
82:
83: igs_ps_usec_occurs_pkg.update_row (
84: x_rowid => c_usec_occurs_rec.ROWID,
85: x_unit_section_occurrence_id => c_usec_occurs_rec.unit_section_occurrence_id,
86: x_uoo_id => c_usec_occurs_rec.uoo_id,
87: x_monday => c_usec_occurs_rec.monday,

Line 794: CURSOR c_uso(cp_n_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE) IS

790: AND cal_type = p_c_cal_type ;
791:
792: c_usec_rec c_usec%ROWTYPE;
793:
794: CURSOR c_uso(cp_n_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE) IS
795: SELECT uso.rowid, uso.*
796: FROM igs_ps_usec_occurs_all uso
797: WHERE uso.uoo_id = cp_n_uoo_id
798: AND building_code IS NOT NULL;

Line 796: FROM igs_ps_usec_occurs_all uso

792: c_usec_rec c_usec%ROWTYPE;
793:
794: CURSOR c_uso(cp_n_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE) IS
795: SELECT uso.rowid, uso.*
796: FROM igs_ps_usec_occurs_all uso
797: WHERE uso.uoo_id = cp_n_uoo_id
798: AND building_code IS NOT NULL;
799:
800: CURSOR cur_unit_audit(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

Line 1209: igs_ps_usec_occurs_pkg.update_row (

1205: IF p_usec_rec.unit_section_status = 'CANCELLED' THEN
1206: IF (NVL(fnd_profile.value('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1207: IF p_usec_rec.status <> 'E' THEN
1208: FOR rec_uso IN c_uso(c_usec_rec.uoo_id) LOOP
1209: igs_ps_usec_occurs_pkg.update_row (
1210: X_Mode => 'R',
1211: X_RowId => rec_uso.rowid ,
1212: X_unit_section_occurrence_id => rec_uso.unit_section_occurrence_id,
1213: X_uoo_id => rec_uso.uoo_id,

Line 1763: FROM igs_ps_usec_occurs_all

1759: WHERE unit_section_occurrence_id = cp_uso_id;
1760:
1761: CURSOR cur_occur(cp_uso_id IN NUMBER) IS
1762: SELECT *
1763: FROM igs_ps_usec_occurs_all
1764: WHERE unit_section_occurrence_id = cp_uso_id;
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

Line 1767: CURSOR c_shadow_num(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS

1763: FROM igs_ps_usec_occurs_all
1764: WHERE unit_section_occurrence_id = cp_uso_id;
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;

Line 1772: l_new_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';

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';
1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';

Line 1773: l_new_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';

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';
1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';

Line 1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';

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';
1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1778: l_new_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';

Line 1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';

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';
1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1778: l_new_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1779: l_new_start_time VARCHAR2(50):='1' ;

Line 1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';

1772: l_new_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1773: l_new_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1778: l_new_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1779: l_new_start_time VARCHAR2(50):='1' ;
1780: l_new_end_time VARCHAR2(50) :='1';

Line 1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';

1773: l_new_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1778: l_new_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1779: l_new_start_time VARCHAR2(50):='1' ;
1780: l_new_end_time VARCHAR2(50) :='1';
1781: l_new_building_code VARCHAR2(10):='1';

Line 1778: l_new_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';

1774: l_new_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1775: l_new_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1776: l_new_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1777: l_new_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1778: l_new_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1779: l_new_start_time VARCHAR2(50):='1' ;
1780: l_new_end_time VARCHAR2(50) :='1';
1781: l_new_building_code VARCHAR2(10):='1';
1782: l_new_room_code VARCHAR2(10):='1';

Line 1784: l_old_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';

1780: l_new_end_time VARCHAR2(50) :='1';
1781: l_new_building_code VARCHAR2(10):='1';
1782: l_new_room_code VARCHAR2(10):='1';
1783:
1784: l_old_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';

Line 1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';

1781: l_new_building_code VARCHAR2(10):='1';
1782: l_new_room_code VARCHAR2(10):='1';
1783:
1784: l_old_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';

Line 1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';

1782: l_new_room_code VARCHAR2(10):='1';
1783:
1784: l_old_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1790: l_old_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';

Line 1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';

1783:
1784: l_old_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1790: l_old_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1791: l_old_start_time VARCHAR2(50):='1' ;

Line 1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';

1784: l_old_monday IGS_PS_USEC_OCCURS_V.monday%TYPE := '1';
1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1790: l_old_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1791: l_old_start_time VARCHAR2(50):='1' ;
1792: l_old_end_time VARCHAR2(50) :='1';

Line 1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';

1785: l_old_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE := '1';
1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1790: l_old_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1791: l_old_start_time VARCHAR2(50):='1' ;
1792: l_old_end_time VARCHAR2(50) :='1';
1793: l_old_building_code VARCHAR2(10):='1';

Line 1790: l_old_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';

1786: l_old_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE := '1';
1787: l_old_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE := '1';
1788: l_old_friday IGS_PS_USEC_OCCURS_V.friday%TYPE := '1';
1789: l_old_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE := '1';
1790: l_old_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE := '1';
1791: l_old_start_time VARCHAR2(50):='1' ;
1792: l_old_end_time VARCHAR2(50) :='1';
1793: l_old_building_code VARCHAR2(10):='1';
1794: l_old_room_code VARCHAR2(10):='1';

Line 1800: l_new_unit_section_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE;

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,
1804: sunday, start_time, end_time, building_code, room_code, instructor_id

Line 1802: CURSOR c_shadow_rec(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS

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,
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;

Line 1808: l_shd_monday IGS_PS_USEC_OCCURS_V.monday%TYPE:= '1';

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';
1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';

Line 1809: l_shd_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE:= '1';

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';
1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';
1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';

Line 1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';

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';
1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';
1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';
1814: l_shd_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE:= '1';

Line 1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';

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';
1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';
1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';
1814: l_shd_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE:= '1';
1815: l_shd_start_time VARCHAR2(50):='1';

Line 1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';

1808: l_shd_monday IGS_PS_USEC_OCCURS_V.monday%TYPE:= '1';
1809: l_shd_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE:= '1';
1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';
1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';
1814: l_shd_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE:= '1';
1815: l_shd_start_time VARCHAR2(50):='1';
1816: l_shd_end_time VARCHAR2(50):='1';

Line 1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';

1809: l_shd_tuesday IGS_PS_USEC_OCCURS_V.tuesday%TYPE:= '1';
1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';
1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';
1814: l_shd_sunday IGS_PS_USEC_OCCURS_V.sunday%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';

Line 1814: l_shd_sunday IGS_PS_USEC_OCCURS_V.sunday%TYPE:= '1';

1810: l_shd_wednesday IGS_PS_USEC_OCCURS_V.wednesday%TYPE:= '1';
1811: l_shd_thursday IGS_PS_USEC_OCCURS_V.thursday%TYPE:= '1';
1812: l_shd_friday IGS_PS_USEC_OCCURS_V.friday%TYPE:= '1';
1813: l_shd_saturday IGS_PS_USEC_OCCURS_V.saturday%TYPE:= '1';
1814: l_shd_sunday IGS_PS_USEC_OCCURS_V.sunday%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';

Line 1820: lv_usec_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE:= 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;
1824: l_insv_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE;

Line 1821: CURSOR c_insv_unit_sec_occur_id(l_unit_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS

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;
1824: l_insv_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE;
1825:

Line 3769: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

3765: WHERE reference_cd_type = cp_c_ref_cd_type;
3766:
3767: rec_ref_flag c_ref_flag%ROWTYPE;
3768:
3769: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
3770: SELECT uso.unit_section_occurrence_id
3771: FROM igs_ps_usec_occurs_all uso
3772: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
3773: AND uso.no_set_day_ind ='N'

Line 3771: FROM igs_ps_usec_occurs_all uso

3767: rec_ref_flag c_ref_flag%ROWTYPE;
3768:
3769: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
3770: SELECT uso.unit_section_occurrence_id
3771: FROM igs_ps_usec_occurs_all uso
3772: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
3773: AND uso.no_set_day_ind ='N'
3774: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
3775:

Line 3778: FROM igs_ps_usec_occurs_all

3774: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
3775:
3776: CURSOR c_ref_code (cp_uso_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS
3777: SELECT 'X'
3778: FROM igs_ps_usec_occurs_all
3779: WHERE unit_section_occurrence_id = cp_uso_id
3780: AND schedule_status = 'PROCESSING';
3781:
3782: l_c_var VARCHAR2(1);

Line 3894: FROM igs_ps_usec_occurs_all

3890: Who When What
3891: ********************************************************************************************** */
3892: CURSOR occur IS
3893: SELECT unit_section_occurrence_id
3894: FROM igs_ps_usec_occurs_all
3895: WHERE uoo_id= p_uoo_id
3896: AND occurrence_identifier=p_occurrence_identifier;
3897:
3898: BEGIN

Line 3999: FROM igs_ps_usec_occurs_all

3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3996:
3997: CURSOR c_uso_chk(p_n_uso_id NUMBER) IS
3998: SELECT schedule_status,abort_flag
3999: FROM igs_ps_usec_occurs_all
4000: WHERE unit_section_occurrence_id = p_n_uso_id;
4001:
4002:
4003: c_uso_chk_rec c_uso_chk%ROWTYPE;

Line 4106: FROM igs_ps_usec_occurs_all

4102: sommukhe 15-NOV-2005 Bug# 4721543, Included the the check for cancelled status of unit section.
4103: ***********************************************************************************************/
4104: CURSOR c_uso_chk(cp_n_uso_id IN NUMBER) IS
4105: SELECT schedule_status,abort_flag
4106: FROM igs_ps_usec_occurs_all
4107: WHERE unit_section_occurrence_id = cp_n_uso_id;
4108: c_uso_chk_rec c_uso_chk%ROWTYPE;
4109:
4110: CURSOR c_usec_chk(cp_n_uoo_id IN NUMBER) IS