APPS.IGS_PS_VAL_CRFC dependencies on IGS_GE_REF_CD_TYPE

Line 9: v_closed_ind IGS_GE_REF_CD_TYPE.closed_ind%TYPE;

5: FUNCTION crsp_val_ref_cd_type(
6: p_reference_cd_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_GE_REF_CD_TYPE.closed_ind%TYPE;
10: CURSOR c_reference_cd_type IS
11: SELECT closed_ind
12: FROM IGS_GE_REF_CD_TYPE
13: WHERE reference_cd_type = p_reference_cd_type;

Line 12: FROM IGS_GE_REF_CD_TYPE

8: RETURN BOOLEAN AS
9: v_closed_ind IGS_GE_REF_CD_TYPE.closed_ind%TYPE;
10: CURSOR c_reference_cd_type IS
11: SELECT closed_ind
12: FROM IGS_GE_REF_CD_TYPE
13: WHERE reference_cd_type = p_reference_cd_type;
14: BEGIN
15: OPEN c_reference_cd_type;
16: FETCH c_reference_cd_type INTO v_closed_ind;

Line 50: v_s_reference_cd_type IGS_GE_REF_CD_TYPE.s_reference_cd_type%TYPE;

46: BEGIN -- crsp_val_crfc_rct
47: -- This module validates whether an open Reference Code Type
48: -- already exists for the System Reference Code Type.
49: DECLARE
50: v_s_reference_cd_type IGS_GE_REF_CD_TYPE.s_reference_cd_type%TYPE;
51: v_count NUMBER DEFAULT 0;
52: CURSOR c_rct IS
53: SELECT rct.s_reference_cd_type
54: FROM IGS_GE_REF_CD_TYPE rct

Line 54: FROM IGS_GE_REF_CD_TYPE rct

50: v_s_reference_cd_type IGS_GE_REF_CD_TYPE.s_reference_cd_type%TYPE;
51: v_count NUMBER DEFAULT 0;
52: CURSOR c_rct IS
53: SELECT rct.s_reference_cd_type
54: FROM IGS_GE_REF_CD_TYPE rct
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(*)

Line 57: cp_s_reference_cd_type IGS_GE_REF_CD_TYPE.s_reference_cd_type%TYPE) IS

53: SELECT rct.s_reference_cd_type
54: FROM IGS_GE_REF_CD_TYPE rct
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

Line 60: IGS_GE_REF_CD_TYPE rct

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
64: crfc.reference_cd <> p_reference_cd) AND