APPS.IGS_AS_SPL_CONS_APPL_PKG dependencies on IGS_AS_VAL_SCAP

Line 82: --svanukur 29-APR-03 Passed uoo_id to IGS_AS_VAL_SCAP.assp_val_suaai_ins , IGS_AS_VAL_SCAP.assp_val_suaai_delet

78:
79: -------------------------------------------------------------------------------------------
80: --Change History:
81: --Who When What
82: --svanukur 29-APR-03 Passed uoo_id to IGS_AS_VAL_SCAP.assp_val_suaai_ins , IGS_AS_VAL_SCAP.assp_val_suaai_delet
83: -- as part of MUS build, # 2829262
84: -------------------------------------------------------------------------------------------
85: PROCEDURE BeforeRowInsertUpdate1(
86: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 96: IF IGS_AS_VAL_SCAP.assp_val_spcc_closed ( new_references.spcl_consideration_cat,

92: -- Validate that inserts/updates are allowed
93: IF p_inserting OR p_updating THEN
94: --
95: -- Validate IGS_AS_SPCL_CONS_CAT closed indicator
96: IF IGS_AS_VAL_SCAP.assp_val_spcc_closed ( new_references.spcl_consideration_cat,
97: v_message_name) = FALSE THEN
98: FND_MESSAGE.SET_NAME('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: APP_EXCEPTION.RAISE_EXCEPTION;

Line 105: IF IGS_AS_VAL_SCAP.assp_val_spco_closed( new_references.sought_outcome,

101: END IF;
102: --
103: -- Validate IGS_AS_SPCL_CONS_OUT closed indicator for
104: -- the sought_outcome field
105: IF IGS_AS_VAL_SCAP.assp_val_spco_closed( new_references.sought_outcome,
106: v_message_name) = FALSE THEN
107: FND_MESSAGE.SET_NAME('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: APP_EXCEPTION.RAISE_EXCEPTION;

Line 114: IF IGS_AS_VAL_SCAP.assp_val_spco_closed( new_references.spcl_consideration_outcome,

110: END IF;
111: --
112: -- Validate IGS_AS_SPCL_CONS_OUT closed indicator for
113: -- the IGS_AS_SPCL_CONS_OUT field
114: IF IGS_AS_VAL_SCAP.assp_val_spco_closed( new_references.spcl_consideration_outcome,
115: v_message_name) = FALSE THEN
116: FND_MESSAGE.SET_NAME('IGS',v_message_name);
117: IGS_GE_MSG_STACK.ADD;
118: APP_EXCEPTION.RAISE_EXCEPTION;

Line 127: IF (IGS_AS_VAL_SCAP.assp_val_suaai_ins ( new_references.person_id,

123: -- the latter being slightly different in that they can not be
124: -- added for SUA status = 'COMPLETED'. That's why this code
125: -- traps for that error and allows valid'n to succeed if it is
126: -- encountered
127: IF (IGS_AS_VAL_SCAP.assp_val_suaai_ins ( new_references.person_id,
128: new_references.course_cd,
129: new_references.unit_cd,
130: new_references.cal_type,
131: new_references.ci_sequence_number,

Line 150: IF IGS_AS_VAL_SCAP.assp_val_suaai_delet(

146: END IF;
147: END IF;
148: IF p_inserting THEN
149: --
150: IF IGS_AS_VAL_SCAP.assp_val_suaai_delet(
151: new_references.person_id,
152: new_references.course_cd,
153: new_references.unit_cd,
154: new_references.cal_type,

Line 169: IGS_AS_VAL_SCAP.assp_val_suaai_delet(

165: END IF;
166: IF p_updating THEN
167: --
168: IF new_references.spcl_consideration_outcome IS NOT NULL AND
169: IGS_AS_VAL_SCAP.assp_val_suaai_delet(
170: new_references.person_id,
171: new_references.course_cd,
172: new_references.unit_cd,
173: new_references.cal_type,