APPS.IGS_PS_OFR_OPT_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

Line 954: CURSOR c_igs_ge_ref_cd_type_all IS

950: WHERE coo_id = cp_coo_id;
951:
952: l_ofr_opt c_ofr_opt%ROWTYPE;
953:
954: CURSOR c_igs_ge_ref_cd_type_all IS
955: SELECT reference_cd_type
956: FROM igs_ge_ref_cd_type_all
957: WHERE mandatory_flag ='Y'
958: AND program_offering_option_flag ='Y'

Line 956: FROM igs_ge_ref_cd_type_all

952: l_ofr_opt c_ofr_opt%ROWTYPE;
953:
954: CURSOR c_igs_ge_ref_cd_type_all IS
955: SELECT reference_cd_type
956: FROM igs_ge_ref_cd_type_all
957: WHERE mandatory_flag ='Y'
958: AND program_offering_option_flag ='Y'
959: AND restricted_flag='Y'
960: AND closed_ind = 'N';

Line 981: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all

977: OPEN c_ofr_opt( p_n_coo_id );
978: FETCH c_ofr_opt INTO l_ofr_opt;
979: CLOSE c_ofr_opt;
980:
981: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all
982: LOOP
983: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)
984: LOOP
985: OPEN c_seq_no;

Line 983: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)

979: CLOSE c_ofr_opt;
980:
981: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all
982: LOOP
983: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)
984: LOOP
985: OPEN c_seq_no;
986: FETCH c_seq_no INTO l_n_sequence_number;
987: CLOSE c_seq_no;

Line 995: x_reference_cd_type => cur_igs_ge_ref_cd_type_all.reference_cd_type,

991: l_c_rowid:=NULL;
992: igs_ps_ent_pt_ref_cd_pkg.insert_row( x_rowid => l_c_rowid,
993: x_course_cd => l_ofr_opt.course_cd,
994: x_sequence_number => l_n_sequence_number,
995: x_reference_cd_type => cur_igs_ge_ref_cd_type_all.reference_cd_type,
996: x_attendance_type => l_ofr_opt.attendance_type,
997: x_cal_type => l_ofr_opt.cal_type,
998: x_location_cd => l_ofr_opt.location_cd,
999: x_version_number => l_ofr_opt.version_number,