DBA Data[Home] [Help]

APPS.IGS_AS_VAL_UAI dependencies on IGS_AS_UNITASS_ITEM_ALL

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 )