DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_PR_OU_TYPE

Line 1437: v_prog_outcome igs_pr_ou_type.s_progression_outcome_type%TYPE;

1433: l_return_status VARCHAR2(10);
1434: l_message VARCHAR2(100);
1435: l_mesg_txt VARCHAR2(4000);
1436: vl_process BOOLEAN;
1437: v_prog_outcome igs_pr_ou_type.s_progression_outcome_type%TYPE;
1438: l_enc_message_name VARCHAR2(2000);
1439: l_app_short_name VARCHAR2(10);
1440: l_message_name VARCHAR2(100);
1441: l_msg_index NUMBER;

Line 2783: FROM igs_pr_stdnt_pr_ou_all pou , igs_pr_ou_type pout

2779: -- checks the eligibility of the student to be moved to the next year of program (unit set)
2780: -- by checking if there is any outcome preventing the progress of the student program attempt
2781: CURSOR c_prog_outcome(cp_select_dt igs_as_su_setatmpt.selection_dt%TYPE) IS
2782: SELECT pou.decision_dt, pout.s_progression_outcome_type
2783: FROM igs_pr_stdnt_pr_ou_all pou , igs_pr_ou_type pout
2784: WHERE pou.person_id = p_person_id AND
2785: pou.course_cd = p_course_cd AND
2786: pou.decision_status = 'APPROVED' AND
2787: pou.decision_dt IS NOT NULL AND