DBA Data[Home] [Help]

APPS.IGS_GR_CRMN_PKG dependencies on IGS_GR_VAL_GC

Line 98: IF IGS_GR_VAL_GC.grdp_val_gc_upd(

94: IF (new_references.ceremony_dt_alias <> old_references.ceremony_dt_alias OR
95: new_references.ceremony_dai_sequence_number <> old_references.ceremony_dai_sequence_number OR
96: new_references.closing_dt_alias <> old_references.closing_dt_alias OR
97: new_references.closing_dai_sequence_number <> old_references.closing_dai_sequence_number) THEN
98: IF IGS_GR_VAL_GC.grdp_val_gc_upd(
99: new_references.grd_cal_type,
100: new_references.grd_ci_sequence_number,
101: new_references.ceremony_number,
102: v_message_name) = FALSE THEN

Line 111: IF IGS_GR_VAL_GC.grdp_val_ve_lot(

107: END IF;
108: END IF;
109: IF p_inserting OR (p_updating AND new_references.venue_cd <> old_references.venue_cd) THEN
110: -- Validate venue is related to a location with a s_location_type of grd_ctr
111: IF IGS_GR_VAL_GC.grdp_val_ve_lot(
112: new_references.venue_cd,
113: v_message_name) = FALSE THEN
114: Fnd_Message.Set_Name('IGS', v_message_name);
115: IGS_GE_MSG_STACK.ADD;

Line 119: IF IGS_GR_VAL_GC.assp_val_ve_closed(

115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: -- Validate venue is not closed
119: IF IGS_GR_VAL_GC.assp_val_ve_closed(
120: new_references.venue_cd,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS', v_message_name);
123: IGS_GE_MSG_STACK.ADD;

Line 133: IF IGS_GR_VAL_GC.grdp_val_gc_dai(

129: new_references.ceremony_dai_sequence_number <> old_references.ceremony_dai_sequence_number OR
130: new_references.closing_dt_alias <> old_references.closing_dt_alias OR
131: new_references.closing_dai_sequence_number <> old_references.closing_dai_sequence_number)) THEN
132: -- Validate the graduation ceremony date aliases
133: IF IGS_GR_VAL_GC.grdp_val_gc_dai(
134: new_references.grd_cal_type,
135: new_references.grd_ci_sequence_number,
136: new_references.ceremony_dt_alias,
137: new_references.ceremony_dai_sequence_number,

Line 168: IF IGS_GR_VAL_GC.grdp_val_gc_times(

164: IF p_inserting OR (p_updating AND
165: (new_references.ceremony_start_time <> old_references.ceremony_start_time OR
166: new_references.ceremony_end_time <> old_references.ceremony_end_time)) THEN
167: -- validate graduation ceremony start and end times
168: IF IGS_GR_VAL_GC.grdp_val_gc_times(
169: NEW_REFERENCES.grd_cal_type,
170: NEW_REFERENCES.grd_ci_sequence_number,
171: NEW_REFERENCES.ceremony_number,
172: NEW_REFERENCES.venue_cd,