APPS.IGS_PR_VAL_SPO dependencies on IGS_PS_GRP

Line 1650: -- Validate if IGS_PS_GRP.course_group_cd is closed.

1646: App_Exception.Raise_Exception;
1647: END prgp_val_spo_drtn;
1648:
1649: --
1650: -- Validate if IGS_PS_GRP.course_group_cd is closed.
1651: FUNCTION crsp_val_cgr_closed(
1652: p_course_group_cd IN VARCHAR2 ,
1653: p_message_name OUT NOCOPY VARCHAR2 )
1654: RETURN BOOLEAN IS

Line 1657: -- Validate if IGS_PS_GRP.course_group_cd is closed.

1653: p_message_name OUT NOCOPY VARCHAR2 )
1654: RETURN BOOLEAN IS
1655: gv_other_detail VARCHAR2(255);
1656: BEGIN -- crsp_val_cgr_closed
1657: -- Validate if IGS_PS_GRP.course_group_cd is closed.
1658: DECLARE
1659: CURSOR c_cg(
1660: cp_course_group_cd IGS_PS_GRP.course_group_cd%TYPE) IS
1661: SELECT closed_ind

Line 1660: cp_course_group_cd IGS_PS_GRP.course_group_cd%TYPE) IS

1656: BEGIN -- crsp_val_cgr_closed
1657: -- Validate if IGS_PS_GRP.course_group_cd is closed.
1658: DECLARE
1659: CURSOR c_cg(
1660: cp_course_group_cd IGS_PS_GRP.course_group_cd%TYPE) IS
1661: SELECT closed_ind
1662: FROM IGS_PS_GRP
1663: WHERE course_group_cd = cp_course_group_cd;
1664: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;

Line 1662: FROM IGS_PS_GRP

1658: DECLARE
1659: CURSOR c_cg(
1660: cp_course_group_cd IGS_PS_GRP.course_group_cd%TYPE) IS
1661: SELECT closed_ind
1662: FROM IGS_PS_GRP
1663: WHERE course_group_cd = cp_course_group_cd;
1664: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;
1665: cst_yes CONSTANT CHAR := 'Y';
1666: BEGIN

Line 1664: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;

1660: cp_course_group_cd IGS_PS_GRP.course_group_cd%TYPE) IS
1661: SELECT closed_ind
1662: FROM IGS_PS_GRP
1663: WHERE course_group_cd = cp_course_group_cd;
1664: v_closed_ind IGS_PS_GRP.closed_ind%TYPE;
1665: cst_yes CONSTANT CHAR := 'Y';
1666: BEGIN
1667: -- Set the default message number
1668: p_message_name := null;