APPS.IGS_EN_SPA_TERMS_PKG dependencies on IGS_PS_OFR_OPT

Line 182: IF NOT IGS_PS_OFR_OPT_PKG.Get_UK_For_Validation (

178: IF (((old_references.coo_id = new_references.coo_id)) OR
179: ((new_references.coo_id IS NULL))) THEN
180: NULL;
181: ELSE
182: IF NOT IGS_PS_OFR_OPT_PKG.Get_UK_For_Validation (
183: new_references.coo_id
184: ) THEN
185: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
186: IGS_GE_MSG_STACK.ADD;

Line 346: PROCEDURE GET_UFK_IGS_PS_OFR_OPT (

342: END IF;
343: CLOSE cur_rowid;
344: END GET_FK_IGS_FI_FEE_CAT;
345:
346: PROCEDURE GET_UFK_IGS_PS_OFR_OPT (
347: x_coo_id IN VARCHAR2
348: ) AS
349: /*
350: || Created By : ckasu

Line 374: END GET_UFK_IGS_PS_OFR_OPT;

370: App_Exception.Raise_Exception;
371: RETURN;
372: END IF;
373: CLOSE cur_rowid;
374: END GET_UFK_IGS_PS_OFR_OPT;
375:
376:
377: FUNCTION get_pk_for_validation (
378: x_term_record_id IN NUMBER

Line 574: FROM igs_ps_ofr_opt cop,

570:
571: Cursor cur_rowid(p_coo_id NUMBER,p_term_cal_type VARCHAR2,p_term_sequence_number VARCHAR2) is
572:
573: SELECT 'x'
574: FROM igs_ps_ofr_opt cop,
575: igs_ca_inst_rel cr
576: WHERE cop.cal_type = cr.sup_cal_type AND
577: cop.coo_id = p_coo_id AND
578: cr.sub_cal_type = p_term_cal_type AND