APPS.IGS_AD_SBMAO_FN_CTTT_PKG dependencies on IGS_AD_INTAK_TRG_TYP

Line 84: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;

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

Line 236: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (

232: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR
233: ((new_references.intake_target_type IS NULL))) THEN
234: NULL;
235: ELSE
236: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
237: new_references.intake_target_type,
238: 'N'
239: )THEN
240: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 397: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(

393: Close cur_rowid;
394:
395: END GET_FK_IGS_ST_GVT_SPSHT_CTL;
396:
397: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
398: x_intake_target_type IN VARCHAR2
399: ) AS
400:
401: CURSOR cur_rowid IS

Line 421: END GET_FK_IGS_AD_INTAK_TRG_TYP;

417: Return;
418: END IF;
419: Close cur_rowid;
420:
421: END GET_FK_IGS_AD_INTAK_TRG_TYP;
422:
423: PROCEDURE GET_FK_IGS_OR_UNIT (
424: x_org_unit_cd IN VARCHAR2,
425: x_start_dt IN DATE