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.

[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_OCCURS_V

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