APPS.IGS_PS_ENT_PT_REF_CD_PKG dependencies on IGS_PS_VAL_CEPRC

Line 5: -- igs_ps_val_ceprc.crsp_val_ceprc_uref from beforerowinsertupdatedelete1

1: package body IGS_PS_ENT_PT_REF_CD_PKG AS
2: /* $Header: IGSPI10B.pls 120.1 2006/05/29 07:29:39 sarakshi noship $ */
3:
4: --sarakshi 20-Apr-2002 As a part of the bug #2146753 removed the call to the function
5: -- igs_ps_val_ceprc.crsp_val_ceprc_uref from beforerowinsertupdatedelete1
6: -- Also addd few columns in lock_row,update_row which were missing.
7: --sarakshi 27-Apr-2006 Bug#5165619, modified check_parent_existance and created procedure GET_FK_IGS_PS_OFR_UNIT_SET
8:
9: l_rowid VARCHAR2(25);

Line 159: IF IGS_PS_VAL_CEPRC.crsp_val_ceprc_coous (

155: IF p_inserting OR p_updating THEN
156: -- Validate IGS_PS_UNIT sets are valid for the IGS_PS_COURSE offering option
157: IF (new_references.unit_set_cd IS NOT NULL OR
158: new_references.us_version_number IS NOT NULL) THEN
159: IF IGS_PS_VAL_CEPRC.crsp_val_ceprc_coous (
160: new_references.coo_id,
161: new_references.unit_set_cd,
162: new_references.us_version_number,
163: v_message_name) = 'FALSE' THEN

Line 171: IF IGS_PS_VAL_CEPRC.crsp_val_ceprc_uniq (

167: END IF;
168: END IF;
169: END IF;
170: IF p_inserting THEN
171: IF IGS_PS_VAL_CEPRC.crsp_val_ceprc_uniq (
172: new_references.coo_id,
173: new_references.reference_cd_type,
174: new_references.sequence_number,
175: new_references.unit_set_cd,

Line 183: --igs_ps_val_ceprc.crsp_val_ceprc_uref

179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: --As a part of the bug #2146753 removed the call to the function
183: --igs_ps_val_ceprc.crsp_val_ceprc_uref
184: END IF;
185: IF p_deleting THEN
186: IF IGS_PS_VAL_ATL.chk_mandatory_ref_cd(
187: new_references.reference_cd_type) = TRUE THEN