APPS.IGS_PR_VAL_SCPCA dependencies on IGS_PR_S_CRV_PRG_CON

Line 74: v_show_cause_ind IGS_PR_S_CRV_PRG_CON.show_cause_ind%TYPE;

70: -- checking for :
71: -- * Cannot be set if s_crv_prg_conf.show_cause_ind is N
72: -- * Warn if not set if s_crv_prg_conf.show_cause_ind is Y
73: DECLARE
74: v_show_cause_ind IGS_PR_S_CRV_PRG_CON.show_cause_ind%TYPE;
75: CURSOR c_scpc IS
76: SELECT scpc.show_cause_ind
77: FROM IGS_PR_S_CRV_PRG_CON scpc
78: WHERE scpc.course_cd = p_course_cd AND

Line 77: FROM IGS_PR_S_CRV_PRG_CON scpc

73: DECLARE
74: v_show_cause_ind IGS_PR_S_CRV_PRG_CON.show_cause_ind%TYPE;
75: CURSOR c_scpc IS
76: SELECT scpc.show_cause_ind
77: FROM IGS_PR_S_CRV_PRG_CON scpc
78: WHERE scpc.course_cd = p_course_cd AND
79: scpc.version_number = p_version_number;
80: BEGIN
81: -- Set the default message name

Line 130: v_appeal_ind IGS_PR_S_CRV_PRG_CON.appeal_ind%TYPE;

126: -- Validate the appeal length of the s_crv_prg_cal record, checking for :
127: -- * Cannot be set if s_crv_prg_conf.appeal_ind is N
128: -- * Warn if not set if s_crv_prg_conf.appeal_ind is Y
129: DECLARE
130: v_appeal_ind IGS_PR_S_CRV_PRG_CON.appeal_ind%TYPE;
131: CURSOR c_scpc IS
132: SELECT scpc.appeal_ind
133: FROM IGS_PR_S_CRV_PRG_CON scpc
134: WHERE scpc.course_cd = p_course_cd AND

Line 133: FROM IGS_PR_S_CRV_PRG_CON scpc

129: DECLARE
130: v_appeal_ind IGS_PR_S_CRV_PRG_CON.appeal_ind%TYPE;
131: CURSOR c_scpc IS
132: SELECT scpc.appeal_ind
133: FROM IGS_PR_S_CRV_PRG_CON scpc
134: WHERE scpc.course_cd = p_course_cd AND
135: scpc.version_number = p_version_number;
136: BEGIN
137: -- Set the default message name