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_VAL_POS dependencies on IGS_EN_UNIT_SET

Line 158: -- and for IGS_EN_UNIT_SET versions with the uni_set_cd supplied which have a

154: p_message_name := NULL;
155: RETURN TRUE;
156: END IF;
157: -- Check for IGS_PS_OFR_OPT records for the IGS_PS_COURSE offering supplied
158: -- and for IGS_EN_UNIT_SET versions with the uni_set_cd supplied which have a
159: -- IGS_EN_UNIT_SET_STAT.s_unit_set_status of ACTIVE:
160: OPEN c_coo;
161: FETCH c_coo INTO v_dummy;
162: IF (c_coo%NOTFOUND) THEN

Line 159: -- IGS_EN_UNIT_SET_STAT.s_unit_set_status of ACTIVE:

155: RETURN TRUE;
156: END IF;
157: -- Check for IGS_PS_OFR_OPT records for the IGS_PS_COURSE offering supplied
158: -- and for IGS_EN_UNIT_SET versions with the uni_set_cd supplied which have a
159: -- IGS_EN_UNIT_SET_STAT.s_unit_set_status of ACTIVE:
160: OPEN c_coo;
161: FETCH c_coo INTO v_dummy;
162: IF (c_coo%NOTFOUND) THEN
163: -- no record found

Line 196: -- Warn the user if the IGS_EN_UNIT_SET is not linked to the IGS_PS_OFR.

192: p_unit_set_cd IN VARCHAR2 ,
193: p_message_name OUT NOCOPY VARCHAR2 )
194: RETURN BOOLEAN AS
195: BEGIN -- crsp_val_pos_cous
196: -- Warn the user if the IGS_EN_UNIT_SET is not linked to the IGS_PS_OFR.
197: -- Warning only.
198: DECLARE
199: cst_active CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'ACTIVE';
200: v_dummy VARCHAR(1);

Line 199: cst_active CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'ACTIVE';

195: BEGIN -- crsp_val_pos_cous
196: -- Warn the user if the IGS_EN_UNIT_SET is not linked to the IGS_PS_OFR.
197: -- Warning only.
198: DECLARE
199: cst_active CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'ACTIVE';
200: v_dummy VARCHAR(1);
201: CURSOR c_cous_us_uss IS
202: SELECT 'X'
203: FROM IGS_PS_OFR_UNIT_SET cous,

Line 204: IGS_EN_UNIT_SET us,

200: v_dummy VARCHAR(1);
201: CURSOR c_cous_us_uss IS
202: SELECT 'X'
203: FROM IGS_PS_OFR_UNIT_SET cous,
204: IGS_EN_UNIT_SET us,
205: IGS_EN_UNIT_SET_STAT uss
206: WHERE cous.course_cd = p_course_cd AND
207: cous.crv_version_number = p_crv_version_number AND
208: cous.cal_type = p_cal_type AND

Line 205: IGS_EN_UNIT_SET_STAT uss

201: CURSOR c_cous_us_uss IS
202: SELECT 'X'
203: FROM IGS_PS_OFR_UNIT_SET cous,
204: IGS_EN_UNIT_SET us,
205: IGS_EN_UNIT_SET_STAT uss
206: WHERE cous.course_cd = p_course_cd AND
207: cous.crv_version_number = p_crv_version_number AND
208: cous.cal_type = p_cal_type AND
209: cous.unit_set_cd = p_unit_set_cd AND

Line 507: p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,

503: END crsp_val_pos_iu;
504: --
505: -- Validate a least one version of the IGS_PS_UNIT set is active.
506: FUNCTION crsp_val_us_active(
507: p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,
508: p_message_name OUT NOCOPY VARCHAR2 )
509: RETURN BOOLEAN AS
510: BEGIN -- crsp_val_us_active
511: -- Validate the IGS_EN_UNIT_SET contains at least one version which is ACTIVE.

Line 511: -- Validate the IGS_EN_UNIT_SET contains at least one version which is ACTIVE.

507: p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,
508: p_message_name OUT NOCOPY VARCHAR2 )
509: RETURN BOOLEAN AS
510: BEGIN -- crsp_val_us_active
511: -- Validate the IGS_EN_UNIT_SET contains at least one version which is ACTIVE.
512: DECLARE
513: v_dummy VARCHAR2(1);
514: CURSOR c_us_uss IS
515: SELECT 'X'

Line 516: FROM IGS_EN_UNIT_SET us,

512: DECLARE
513: v_dummy VARCHAR2(1);
514: CURSOR c_us_uss IS
515: SELECT 'X'
516: FROM IGS_EN_UNIT_SET us,
517: IGS_EN_UNIT_SET_STAT uss
518: WHERE us.unit_set_cd = p_unit_set_cd AND
519: us.unit_set_status = uss.unit_set_status AND
520: uss.s_unit_set_status = 'ACTIVE';

Line 517: IGS_EN_UNIT_SET_STAT uss

513: v_dummy VARCHAR2(1);
514: CURSOR c_us_uss IS
515: SELECT 'X'
516: FROM IGS_EN_UNIT_SET us,
517: IGS_EN_UNIT_SET_STAT uss
518: WHERE us.unit_set_cd = p_unit_set_cd AND
519: us.unit_set_status = uss.unit_set_status AND
520: uss.s_unit_set_status = 'ACTIVE';
521: BEGIN

Line 527: -- Check if the IGS_EN_UNIT_SET contains an active version:

523: IF p_unit_set_cd IS NULL THEN
524: p_message_name := NULL;
525: RETURN TRUE;
526: END IF;
527: -- Check if the IGS_EN_UNIT_SET contains an active version:
528: OPEN c_us_uss;
529: FETCH c_us_uss INTO v_dummy;
530: --If no active record is found return error:
531: IF (c_us_uss%NOTFOUND) THEN