APPS.IGS_AD_SBMAO_FN_UITT_PKG dependencies on IGS_AD_INTAK_TRG_TYP

Line 83: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;

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

Line 222: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (

218: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR
219: ((new_references.intake_target_type IS NULL))) THEN
220: NULL;
221: ELSE
222: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
223: new_references.intake_target_type,
224: 'N'
225: )THEN
226: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 369: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(

365: Close cur_rowid;
366:
367: END GET_FK_IGS_ST_GVT_SPSHT_CTL;
368:
369: PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
370: x_intake_target_type IN VARCHAR2
371: ) AS
372:
373: CURSOR cur_rowid IS

Line 393: END GET_FK_IGS_AD_INTAK_TRG_TYP;

389: Return;
390: END IF;
391: Close cur_rowid;
392:
393: END GET_FK_IGS_AD_INTAK_TRG_TYP;
394:
395: PROCEDURE GET_FK_IGS_OR_UNIT (
396: x_org_unit_cd IN VARCHAR2,
397: x_start_dt IN DATE