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_VAL_COUSR dependencies on IGS_PS_OFR_UNIT_SET

Line 74: cp_unit_set_cd IGS_PS_OFR_UNIT_SET.unit_set_cd%TYPE,

70: -- of itself.
71: DECLARE
72: v_dummy VARCHAR2(1);
73: CURSOR c_cous (
74: cp_unit_set_cd IGS_PS_OFR_UNIT_SET.unit_set_cd%TYPE,
75: cp_us_version_number IGS_PS_OFR_UNIT_SET.us_version_number%TYPE) IS
76: SELECT 'x'
77: FROM IGS_PS_OFR_UNIT_SET cous
78: WHERE cous.course_cd = p_course_cd AND

Line 75: cp_us_version_number IGS_PS_OFR_UNIT_SET.us_version_number%TYPE) IS

71: DECLARE
72: v_dummy VARCHAR2(1);
73: CURSOR c_cous (
74: cp_unit_set_cd IGS_PS_OFR_UNIT_SET.unit_set_cd%TYPE,
75: cp_us_version_number IGS_PS_OFR_UNIT_SET.us_version_number%TYPE) IS
76: SELECT 'x'
77: FROM IGS_PS_OFR_UNIT_SET cous
78: WHERE cous.course_cd = p_course_cd AND
79: cous.crv_version_number = p_crv_version_number AND

Line 77: FROM IGS_PS_OFR_UNIT_SET cous

73: CURSOR c_cous (
74: cp_unit_set_cd IGS_PS_OFR_UNIT_SET.unit_set_cd%TYPE,
75: cp_us_version_number IGS_PS_OFR_UNIT_SET.us_version_number%TYPE) IS
76: SELECT 'x'
77: FROM IGS_PS_OFR_UNIT_SET cous
78: WHERE cous.course_cd = p_course_cd AND
79: cous.crv_version_number = p_crv_version_number AND
80: cous.cal_type = p_cal_type AND
81: cous.unit_set_cd = cp_unit_set_cd AND

Line 201: -- be created with a IGS_PS_OFR_UNIT_SET as the superior when the

197: RETURN BOOLEAN AS
198: BEGIN
199: -- crsp_val_cousr_sub
200: -- This module validates that a IGS_PS_OF_UNT_SET_RL record can not
201: -- be created with a IGS_PS_OFR_UNIT_SET as the superior when the
202: -- only_as_sub_ind for that IGS_PS_OFR_UNIT_SET is set to 'Y'.
203: BEGIN
204: -- set default vaule
205: p_message_name := NUll;

Line 202: -- only_as_sub_ind for that IGS_PS_OFR_UNIT_SET is set to 'Y'.

198: BEGIN
199: -- crsp_val_cousr_sub
200: -- This module validates that a IGS_PS_OF_UNT_SET_RL record can not
201: -- be created with a IGS_PS_OFR_UNIT_SET as the superior when the
202: -- only_as_sub_ind for that IGS_PS_OFR_UNIT_SET is set to 'Y'.
203: BEGIN
204: -- set default vaule
205: p_message_name := NUll;
206: IF IGS_PS_GEN_003.CRSP_GET_COUS_SUBIND (

Line 232: -- with a IGS_PS_OFR_UNIT_SET as the subordinate when the IGS_PS_UNIT set is

228: RETURN BOOLEAN AS
229: BEGIN
230: -- crsp_val_cousr_cacus
231: -- validate that a crs_off_set_relationship record can't be created
232: -- with a IGS_PS_OFR_UNIT_SET as the subordinate when the IGS_PS_UNIT set is
233: -- restricting an IGS_PS_COURSE offering option admission category
234: DECLARE
235: v_unit_set_cd IGS_PS_COO_AD_UNIT_S.unit_set_cd%TYPE;
236: CURSOR c_cacus IS