DBA Data[Home] [Help]

APPS.IGS_AS_VAL_UAI dependencies on IGS_AS_UNITASS_ITEM_ALL

Line 37: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,

33: PRAGMA RESTRICT_REFERENCES (crsp_val_ucl_closed,WNDS);
34: --
35: -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
36: FUNCTION assp_val_uai_links(
37: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,

Line 38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,

34: --
35: -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
36: FUNCTION assp_val_uai_links(
37: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
42: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,

Line 39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,

35: -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
36: FUNCTION assp_val_uai_links(
37: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
42: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
43: --ijeddy, Bug 3201661, Grade Book.

Line 40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,

36: FUNCTION assp_val_uai_links(
37: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
42: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
43: --ijeddy, Bug 3201661, Grade Book.
44: p_location_cd IN VARCHAR2,

Line 41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,

37: p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
42: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
43: --ijeddy, Bug 3201661, Grade Book.
44: p_location_cd IN VARCHAR2,
45: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,

Line 42: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,

38: p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39: p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
42: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
43: --ijeddy, Bug 3201661, Grade Book.
44: p_location_cd IN VARCHAR2,
45: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,
46: p_unit_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,