APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_WAV_PR_PREQS

Line 984: CURSOR cur_pre_req_wav_programs(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,

980: FROM igs_fi_waiver_pgms pgms
981: WHERE pgms.rowid = cp_rollover_rowid;
982:
983: --Cursor to select the prereq waiver programs of the waiver program to be rolled over.
984: CURSOR cur_pre_req_wav_programs(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
985: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
986: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
987: SELECT sup_waiver_name,
988: sub_waiver_name,

Line 991: FROM igs_fi_wav_pr_preqs

987: SELECT sup_waiver_name,
988: sub_waiver_name,
989: fee_cal_type,
990: fee_ci_sequence_number
991: FROM igs_fi_wav_pr_preqs
992: WHERE sub_waiver_name = cp_v_waiver_name
993: AND fee_cal_type = cp_v_fee_cal_type
994: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
995: --Cursor to Check whether the prereq program already exists in the destincation calendar

Line 996: CURSOR cur_prereq_wav_prgms_exist(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,

992: WHERE sub_waiver_name = cp_v_waiver_name
993: AND fee_cal_type = cp_v_fee_cal_type
994: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
995: --Cursor to Check whether the prereq program already exists in the destincation calendar
996: CURSOR cur_prereq_wav_prgms_exist(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
997: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
998: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
999: SELECT 'x'
1000: FROM igs_fi_waiver_pgms

Line 1006: CURSOR cur_stud_waiver_assign(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,

1002: AND fee_cal_type = cp_v_fee_cal_type
1003: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
1004:
1005: --Cursor to select the Student waiver Assignment for Rolling over.
1006: CURSOR cur_stud_waiver_assign(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
1007: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
1008: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1009: SELECT stuwavpgm.*
1010: FROM igs_fi_wav_std_pgms stuwavpgm

Line 1020: l_waiver_relation_id igs_fi_wav_pr_preqs.waiver_relation_id%TYPE;

1016: l_cur_waiver_pgms cur_waiver_pgms%ROWTYPE;
1017: l_cur_pre_req_wav_programs cur_pre_req_wav_programs%ROWTYPE;
1018: l_cur_prereq_wav_prgms_exist cur_prereq_wav_prgms_exist%ROWTYPE;
1019: l_cur_stud_waiver_assign cur_stud_waiver_assign%ROWTYPE;
1020: l_waiver_relation_id igs_fi_wav_pr_preqs.waiver_relation_id%TYPE;
1021: l_waiver_student_id igs_fi_wav_std_pgms.waiver_student_id%TYPE;
1022: l_waiver_pgm_found_flag BOOLEAN;
1023: e_expected_error EXCEPTION;
1024: l_rowid ROWID;

Line 1116: igs_fi_wav_pr_preqs_pkg.insert_row(x_rowid => l_rowid,

1112: CLOSE cur_prereq_wav_prgms_exist;
1113: l_rowid := NULL;
1114: l_waiver_relation_id := NULL;
1115: --Insert the PRe req Waiver program to the destination calendar in the waiver pre req table.
1116: igs_fi_wav_pr_preqs_pkg.insert_row(x_rowid => l_rowid,
1117: x_waiver_relation_id => l_waiver_relation_id,
1118: x_fee_cal_type => l_cur_pre_req_wav_programs.fee_cal_type,
1119: x_fee_ci_sequence_number => p_n_dest_fee_ci_seq_number,
1120: x_sup_waiver_name => l_cur_pre_req_wav_programs.sup_waiver_name,