APPS.IGS_AD_SBMAO_FN_AMTT_PKG dependencies on IGS_AD_INTAK_TRG_TYP

Line 89: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;

85: p_updating IN BOOLEAN DEFAULT FALSE,
86: p_deleting IN BOOLEAN DEFAULT FALSE
87: ) AS
88: v_message_name VARCHAR2(30);
89: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;
90: BEGIN
91: -- Validate Funding Source closed ind.
92: IF p_inserting OR
93: (old_references.funding_source <> new_references.funding_source) THEN

Line 242: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (

238: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR
239: ((new_references.intake_target_type IS NULL))) THEN
240: NULL;
241: ELSE
242: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
243: new_references.intake_target_type,
244: 'N'
245: )THEN
246: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 401: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(

397: Close cur_rowid;
398:
399: END GET_FK_IGS_ST_GVT_SPSHT_CTL;
400:
401: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
402: x_intake_target_type IN VARCHAR2
403: ) AS
404:
405: CURSOR cur_rowid IS

Line 425: END GET_FK_IGS_AD_INTAK_TRG_TYP;

421: Return;
422: END IF;
423: Close cur_rowid;
424:
425: END GET_FK_IGS_AD_INTAK_TRG_TYP;
426:
427: PROCEDURE GET_FK_IGS_OR_UNIT (
428: x_org_unit_cd IN VARCHAR2,
429: x_start_dt IN DATE