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_AS_VAL_UAI dependencies on IGS_AS_UNITASS_ITEM

Line 124: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,

120: END crsp_val_ucl_closed;
121: --
122: -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
123: FUNCTION assp_val_uai_links(
124: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,

Line 125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,

121: --
122: -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
123: FUNCTION assp_val_uai_links(
124: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,

Line 126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,

122: -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
123: FUNCTION assp_val_uai_links(
124: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
130: p_location_cd IN VARCHAR2,

Line 127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,

123: FUNCTION assp_val_uai_links(
124: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
130: p_location_cd IN VARCHAR2,
131: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,

Line 128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,

124: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
130: p_location_cd IN VARCHAR2,
131: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,
132: p_unit_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,

Line 129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,

125: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
126: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
130: p_location_cd IN VARCHAR2,
131: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,
132: p_unit_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
133: p_message_name OUT NOCOPY VARCHAR2 )

Line 300: IGS_AS_UNITASS_ITEM uai

296: CURSOR c_uai IS
297: SELECT 'x'
298: FROM IGS_AS_ASSESSMNT_TYP atyp,
299: IGS_AS_ASSESSMNT_ITM ai,
300: IGS_AS_UNITASS_ITEM uai
301: WHERE atyp.examinable_ind = 'Y' AND
302: ai.assessment_type = atyp.assessment_type AND
303: uai.ass_id = ai.ass_id AND
304: uai.unit_cd = p_unit_cd AND

Line 437: FROM IGS_AS_UNITASS_ITEM uai,

433: -- only for items that have not been deleted
434: DECLARE
435: CURSOR c_uai IS
436: SELECT 'x'
437: FROM IGS_AS_UNITASS_ITEM uai,
438: IGS_AS_ASSESSMNT_ITM ai,
439: IGS_AS_ASSESSMNT_TYP atyp
440: WHERE atyp.examinable_ind = 'N' AND
441: atyp.ASSESSMENT_TYPE = p_assessment_type AND

Line 519: IGS_AS_UNITASS_ITEM uai

515: CURSOR c_uai IS
516: SELECT 'x'
517: FROM IGS_AS_ASSESSMNT_TYP atyp,
518: IGS_AS_ASSESSMNT_ITM ai,
519: IGS_AS_UNITASS_ITEM uai
520: WHERE atyp.examinable_ind = 'Y' AND
521: ai.assessment_type = atyp.assessment_type AND
522: uai.ass_id = ai.ass_id AND
523: uai.unit_cd = p_unit_cd AND

Line 570: -- Validate that the IGS_AS_UNITASS_ITEM's IGS_AD_LOCATION, mode and class

566: p_unit_mode IN VARCHAR2 )
567: RETURN CHAR IS
568: v_message_name VARCHAR2(30);
569: BEGIN -- assp_val_sua_uai
570: -- Validate that the IGS_AS_UNITASS_ITEM's IGS_AD_LOCATION, mode and class
571: -- are applicable for the student
572: --ijeddy, Bug 3201661, Grade Book.Obsoleted
573: RETURN 'TRUE';
574: END assp_val_sua_uai;

Line 641: -- Validate that can update the IGS_AS_UNITASS_ITEM.

637: p_message_name OUT NOCOPY VARCHAR2 )
638: RETURN BOOLEAN IS
639: gv_other_detail VARCHAR2(255);
640: BEGIN -- assp_val_uai_uapi
641: -- Validate that can update the IGS_AS_UNITASS_ITEM.
642: -- Modification is not allowed if :
643: -- logically deleting and the item belongs to a pattern. It must be removed
644: -- from the pattern first.
645: -- Updating IGS_AD_LOCATION, IGS_PS_UNIT mode or IGS_PS_UNIT class and the item belongs to a