APPS.IGS_GR_VAL_GR dependencies on IGS_GR_APRV_STAT

Line 355: v_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;

351: RETURN BOOLEAN AS
352: BEGIN -- grdp_val_gr_gst
353: -- This routine validates the setting of graduand.graduand_status
354: DECLARE
355: v_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;
356: v_new_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
357: v_old_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
358: cst_potential CONSTANT VARCHAR2(12) := 'POTENTIAL';
359: cst_graduated CONSTANT VARCHAR2(12) := 'GRADUATED';

Line 367: FROM IGS_GR_APRV_STAT gas

363: cst_attending CONSTANT VARCHAR2(12) := 'ATTENDING';
364: v_exit_loop BOOLEAN;
365: CURSOR c_gas IS
366: SELECT gas.s_graduand_appr_status
367: FROM IGS_GR_APRV_STAT gas
368: WHERE gas.graduand_appr_status = p_graduand_appr_status;
369: CURSOR c_gst (
370: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)
371: IS

Line 557: v_gas_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;

553: RETURN BOOLEAN AS
554: BEGIN -- grdp_val_gr_gas
555: DECLARE
556: v_gst_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
557: v_gas_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;
558: cst_graduated CONSTANT VARCHAR2(9) := 'GRADUATED';
559: cst_surrender CONSTANT VARCHAR2(9) := 'SURRENDER';
560: cst_approved CONSTANT VARCHAR2(8) := 'APPROVED';
561: CURSOR c_gst IS

Line 567: FROM IGS_GR_APRV_STAT gas

563: FROM IGS_GR_STAT gst
564: WHERE gst.graduand_status = p_graduand_status;
565: CURSOR c_gas IS
566: SELECT gas.s_graduand_appr_status
567: FROM IGS_GR_APRV_STAT gas
568: WHERE gas.graduand_appr_status = p_new_graduand_appr_status;
569: BEGIN
570: -- Set the default message number
571: p_message_name := NULL;

Line 1292: p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE ,

1288: END grdp_val_gr_caw;
1289: --
1290: -- Validate if graduand approval status is closed.
1291: FUNCTION grdp_val_gas_closed(
1292: p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE ,
1293: p_message_name OUT NOCOPY VARCHAR2 )
1294: RETURN BOOLEAN AS
1295: BEGIN -- grdp_val_gas_closed
1296: -- Validate if the graduand approval status is closed

Line 1301: FROM IGS_GR_APRV_STAT gas

1297: DECLARE
1298: v_gas_found VARCHAR2(1);
1299: CURSOR c_gas IS
1300: SELECT 'x'
1301: FROM IGS_GR_APRV_STAT gas
1302: WHERE gas.graduand_appr_status = p_graduand_appr_status AND
1303: gas.closed_ind = 'Y';
1304: BEGIN
1305: p_message_name := NULL;