APPS.IGS_AD_SBM_AOU_FNDTT_PKG dependencies on IGS_AD_INTAK_TRG_TYP

Line 81: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;

77: p_updating IN BOOLEAN DEFAULT FALSE,
78: p_deleting IN BOOLEAN DEFAULT FALSE
79: ) AS
80: v_message_name VARCHAR2(30);
81: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;
82: BEGIN
83: -- Validate Funding Source closed ind.
84: IF p_inserting OR
85: (old_references.funding_source <> new_references.funding_source) THEN

Line 209: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (

205: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR
206: ((new_references.intake_target_type IS NULL))) THEN
207: NULL;
208: ELSE
209: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
210: new_references.intake_target_type,
211: 'N'
212: )THEN
213: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 342: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(

338: Close cur_rowid;
339:
340: END GET_FK_IGS_ST_GVT_SPSHT_CTL;
341:
342: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
343: x_intake_target_type IN VARCHAR2
344: ) AS
345:
346: CURSOR cur_rowid IS

Line 366: END GET_FK_IGS_AD_INTAK_TRG_TYP;

362: Return;
363: END IF;
364: Close cur_rowid;
365:
366: END GET_FK_IGS_AD_INTAK_TRG_TYP;
367:
368: PROCEDURE GET_FK_IGS_OR_UNIT (
369: x_org_unit_cd IN VARCHAR2,
370: x_start_dt IN DATE