APPS.IGS_AD_SBMPS_FN_ITTT_PKG dependencies on IGS_AD_INTAK_TRG_TYP

Line 91: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;

87: p_updating IN BOOLEAN DEFAULT FALSE,
88: p_deleting IN BOOLEAN DEFAULT FALSE
89: ) as
90: v_message_name VARCHAR2(30);
91: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;
92: BEGIN
93: -- Validate Intake target Type closed ind.
94: IF p_inserting OR
95: (old_references.intake_target_type <> new_references.intake_target_type) THEN

Line 191: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (

187: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR
188: ((new_references.intake_target_type IS NULL))) THEN
189: NULL;
190: ELSE
191: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
192: new_references.intake_target_type,
193: 'N'
194: )THEN
195: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 292: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(

288: Close cur_rowid;
289:
290: END GET_FK_IGS_AD_SBM_PS_FNTRGT;
291:
292: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
293: x_intake_target_type IN VARCHAR2
294: ) as
295:
296: CURSOR cur_rowid IS

Line 316: END GET_FK_IGS_AD_INTAK_TRG_TYP;

312: Return;
313: END IF;
314: Close cur_rowid;
315:
316: END GET_FK_IGS_AD_INTAK_TRG_TYP;
317:
318: PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
319: x_override_s_amount_type IN VARCHAR2
320: ) as