APPS.IGS_PS_VAL_CRFC dependencies on IGS_PS_REF_CD

Line 40: p_course_cd IN IGS_PS_REF_CD.course_cd%TYPE ,

36: END crsp_val_ref_cd_type;
37: --
38: -- Validate that only one open reference code type exists
39: FUNCTION crsp_val_crfc_rct(
40: p_course_cd IN IGS_PS_REF_CD.course_cd%TYPE ,
41: p_version_number IN IGS_PS_REF_CD.version_number%TYPE ,
42: p_reference_cd_type IN VARCHAR2 ,
43: p_reference_cd IN IGS_PS_REF_CD.reference_cd%TYPE ,
44: p_message_name OUT NOCOPY VARCHAR2 )

Line 41: p_version_number IN IGS_PS_REF_CD.version_number%TYPE ,

37: --
38: -- Validate that only one open reference code type exists
39: FUNCTION crsp_val_crfc_rct(
40: p_course_cd IN IGS_PS_REF_CD.course_cd%TYPE ,
41: p_version_number IN IGS_PS_REF_CD.version_number%TYPE ,
42: p_reference_cd_type IN VARCHAR2 ,
43: p_reference_cd IN IGS_PS_REF_CD.reference_cd%TYPE ,
44: p_message_name OUT NOCOPY VARCHAR2 )
45: RETURN BOOLEAN AS

Line 43: p_reference_cd IN IGS_PS_REF_CD.reference_cd%TYPE ,

39: FUNCTION crsp_val_crfc_rct(
40: p_course_cd IN IGS_PS_REF_CD.course_cd%TYPE ,
41: p_version_number IN IGS_PS_REF_CD.version_number%TYPE ,
42: p_reference_cd_type IN VARCHAR2 ,
43: p_reference_cd IN IGS_PS_REF_CD.reference_cd%TYPE ,
44: p_message_name OUT NOCOPY VARCHAR2 )
45: RETURN BOOLEAN AS
46: BEGIN -- crsp_val_crfc_rct
47: -- This module validates whether an open Reference Code Type

Line 59: FROM IGS_PS_REF_CD crfc,

55: WHERE rct.reference_cd_type = p_reference_cd_type;
56: CURSOR c_crfc_rct (
57: cp_s_reference_cd_type IGS_GE_REF_CD_TYPE.s_reference_cd_type%TYPE) IS
58: SELECT COUNT(*)
59: FROM IGS_PS_REF_CD crfc,
60: IGS_GE_REF_CD_TYPE rct
61: WHERE crfc.course_cd = p_course_cd AND
62: crfc.version_number = p_version_number AND
63: (crfc.reference_cd_type <> p_reference_cd_type OR