APPS.IGS_PS_OFR_OPT_PKG dependencies on IGS_GE_REF_CD

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 962: CURSOR c_igs_ge_ref_cd ( cp_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE ) IS

958: AND program_offering_option_flag ='Y'
959: AND restricted_flag='Y'
960: AND closed_ind = 'N';
961:
962: CURSOR c_igs_ge_ref_cd ( cp_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE ) IS
963: SELECT reference_cd,
964: description
965: FROM igs_ge_ref_cd
966: WHERE reference_cd_type = cp_reference_cd_type

Line 965: FROM igs_ge_ref_cd

961:
962: CURSOR c_igs_ge_ref_cd ( cp_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE ) IS
963: SELECT reference_cd,
964: description
965: FROM igs_ge_ref_cd
966: WHERE reference_cd_type = cp_reference_cd_type
967: AND default_flag = 'Y';
968:
969: CURSOR c_seq_no IS

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,

Line 1004: x_reference_cd => cur_igs_ge_ref_cd.reference_cd,

1000: x_attendance_mode => l_ofr_opt.attendance_mode,
1001: x_coo_id => p_n_coo_id,
1002: x_unit_set_cd => NULL,
1003: x_us_version_number => NULL,
1004: x_reference_cd => cur_igs_ge_ref_cd.reference_cd,
1005: x_description => cur_igs_ge_ref_cd.description,
1006: x_mode => 'R' );
1007: EXCEPTION
1008: -- The failure of insertion of reference code should not stop the creation of new program offering option.

Line 1005: x_description => cur_igs_ge_ref_cd.description,

1001: x_coo_id => p_n_coo_id,
1002: x_unit_set_cd => NULL,
1003: x_us_version_number => NULL,
1004: x_reference_cd => cur_igs_ge_ref_cd.reference_cd,
1005: x_description => cur_igs_ge_ref_cd.description,
1006: x_mode => 'R' );
1007: EXCEPTION
1008: -- The failure of insertion of reference code should not stop the creation of new program offering option.
1009: -- Hence any exception raised by the TBH is trapped and the current processing is allowed to proceed.