[Home] [Help]
923:
924: PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
925: p_class_standing IN igs_pr_css_class_std_v.class_standing%TYPE ,
926: p_program_type IN igs_ps_ver_all.course_type%TYPE ,
927: p_dl_std_code OUT NOCOPY igf_ap_class_std_map.dl_std_code%TYPE ,
928: p_cl_std_code OUT NOCOPY igf_ap_class_std_map.cl_std_code%TYPE )
929: AS
930: /***************************************************************
931: Created By : masehgal
924: PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
925: p_class_standing IN igs_pr_css_class_std_v.class_standing%TYPE ,
926: p_program_type IN igs_ps_ver_all.course_type%TYPE ,
927: p_dl_std_code OUT NOCOPY igf_ap_class_std_map.dl_std_code%TYPE ,
928: p_cl_std_code OUT NOCOPY igf_ap_class_std_map.cl_std_code%TYPE )
929: AS
930: /***************************************************************
931: Created By : masehgal
932: Date Created By : 10-Oct-2002
961: -- Cursor to get dl_std_code
962: CURSOR c_dl_cl_std_code ( cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
963: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,
965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,
967: CSM.cl_std_code
968: FROM igf_ap_class_std_map CSM ,
969: igf_ap_pr_prg_type PPT
964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,
965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,
967: CSM.cl_std_code
968: FROM igf_ap_class_std_map CSM ,
969: igf_ap_pr_prg_type PPT
970: WHERE PPT.ppt_id = CSM.ppt_id
971: AND PPT.igs_pr_cs_schdl_id = cp_cs_schdl_id
972: AND PPT.cal_type = cp_ci_cal_type
1093: -- Declarations as part of bug 2385334
1094: lv_class_standing igs_pr_css_class_std_v.class_standing%TYPE;
1095: lv_program_type igs_ps_ver_all.course_type%TYPE;
1096: -- defined for Integration Enhancements build
1097: lv_dl_std_code igf_ap_class_std_map.dl_std_code%TYPE;
1098: lv_cl_std_code igf_ap_class_std_map.dl_std_code%TYPE;
1099:
1100: BEGIN
1101:
1094: lv_class_standing igs_pr_css_class_std_v.class_standing%TYPE;
1095: lv_program_type igs_ps_ver_all.course_type%TYPE;
1096: -- defined for Integration Enhancements build
1097: lv_dl_std_code igf_ap_class_std_map.dl_std_code%TYPE;
1098: lv_cl_std_code igf_ap_class_std_map.dl_std_code%TYPE;
1099:
1100: BEGIN
1101:
1102: lv_dl_std_code := NULL;