73: p_updating IN BOOLEAN DEFAULT FALSE,
74: p_deleting IN BOOLEAN DEFAULT FALSE
75: ) AS
76: v_message_name VARCHAR2(30);
77: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;
78: BEGIN
79: -- Validate Intake target Type closed ind.
80: IF p_inserting OR
81: (old_references.intake_target_type <> new_references.intake_target_type) THEN
161: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR
162: ((new_references.intake_target_type IS NULL))) THEN
163: NULL;
164: ELSE
165: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
166: new_references.intake_target_type,
167: 'N'
168: )THEN
169: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
246: Close cur_rowid;
247:
248: END GET_FK_IGS_ST_GVT_SPSHT_CTL;
249:
250: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
251: x_intake_target_type IN VARCHAR2
252: ) AS
253:
254: CURSOR cur_rowid IS
270: Return;
271: END IF;
272: Close cur_rowid;
273:
274: END GET_FK_IGS_AD_INTAK_TRG_TYP;
275:
276:
277: PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
278: x_override_s_amount_type IN VARCHAR2