eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_WAV_STD_PGMS

Line 868: FROM igs_fi_wav_std_pgms fwsp

864: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
865: SELECT fwsp.waiver_name,
866: fwsp.person_id,
867: fwsp.assignment_status_code
868: FROM igs_fi_wav_std_pgms fwsp
869: WHERE fwsp.fee_cal_type = cp_v_fee_cal_type
870: AND fwsp.fee_ci_sequence_number = cp_n_fee_ci_seq_number
871: AND fwsp.waiver_name = cp_v_waiver_name
872: AND fwsp.person_id = cp_n_person_id

Line 1010: FROM igs_fi_wav_std_pgms stuwavpgm

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
1011: WHERE stuwavpgm.fee_cal_type = cp_v_fee_cal_type
1012: AND stuwavpgm.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
1013: AND stuwavpgm.waiver_name = cp_v_waiver_name
1014: AND stuwavpgm.assignment_status_code ='ACTIVE';

Line 1021: l_waiver_student_id igs_fi_wav_std_pgms.waiver_student_id%TYPE;

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;
1025:

Line 1141: igs_fi_wav_std_pgms_pkg.insert_row( x_rowid => l_rowid,

1137: LOOP
1138: --Insert the Student Assignment to the Destination fee calendar.
1139: l_rowid := null;
1140: l_waiver_student_id := null;
1141: igs_fi_wav_std_pgms_pkg.insert_row( x_rowid => l_rowid,
1142: x_waiver_student_id => l_waiver_student_id,
1143: x_fee_cal_type => l_cur_stud_waiver_assign.fee_cal_type,
1144: x_fee_ci_sequence_number => p_n_dest_fee_ci_seq_number,
1145: x_waiver_name => l_cur_stud_waiver_assign.waiver_name,

Line 1188: cp_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,

1184: WHO WHEN WHAT
1185: ***************************************************************** */
1186:
1187: CURSOR stdnt_wav_assgn_cur (
1188: cp_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
1189: cp_fee_ci_seq_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE,
1190: cp_waiver_name igs_fi_wav_std_pgms.waiver_name%TYPE,
1191: cp_new_status igs_fi_wav_std_pgms.assignment_status_code%TYPE) IS
1192: SELECT fwsp.*, fwsp.ROWID

Line 1189: cp_fee_ci_seq_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE,

1185: ***************************************************************** */
1186:
1187: CURSOR stdnt_wav_assgn_cur (
1188: cp_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
1189: cp_fee_ci_seq_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE,
1190: cp_waiver_name igs_fi_wav_std_pgms.waiver_name%TYPE,
1191: cp_new_status igs_fi_wav_std_pgms.assignment_status_code%TYPE) IS
1192: SELECT fwsp.*, fwsp.ROWID
1193: FROM igs_fi_wav_std_pgms fwsp

Line 1190: cp_waiver_name igs_fi_wav_std_pgms.waiver_name%TYPE,

1186:
1187: CURSOR stdnt_wav_assgn_cur (
1188: cp_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
1189: cp_fee_ci_seq_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE,
1190: cp_waiver_name igs_fi_wav_std_pgms.waiver_name%TYPE,
1191: cp_new_status igs_fi_wav_std_pgms.assignment_status_code%TYPE) IS
1192: SELECT fwsp.*, fwsp.ROWID
1193: FROM igs_fi_wav_std_pgms fwsp
1194: WHERE fee_cal_type = cp_fee_cal_type

Line 1191: cp_new_status igs_fi_wav_std_pgms.assignment_status_code%TYPE) IS

1187: CURSOR stdnt_wav_assgn_cur (
1188: cp_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
1189: cp_fee_ci_seq_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE,
1190: cp_waiver_name igs_fi_wav_std_pgms.waiver_name%TYPE,
1191: cp_new_status igs_fi_wav_std_pgms.assignment_status_code%TYPE) IS
1192: SELECT fwsp.*, fwsp.ROWID
1193: FROM igs_fi_wav_std_pgms fwsp
1194: WHERE fee_cal_type = cp_fee_cal_type
1195: AND fee_ci_sequence_number = cp_fee_ci_seq_number

Line 1193: FROM igs_fi_wav_std_pgms fwsp

1189: cp_fee_ci_seq_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE,
1190: cp_waiver_name igs_fi_wav_std_pgms.waiver_name%TYPE,
1191: cp_new_status igs_fi_wav_std_pgms.assignment_status_code%TYPE) IS
1192: SELECT fwsp.*, fwsp.ROWID
1193: FROM igs_fi_wav_std_pgms fwsp
1194: WHERE fee_cal_type = cp_fee_cal_type
1195: AND fee_ci_sequence_number = cp_fee_ci_seq_number
1196: AND waiver_name = cp_waiver_name
1197: AND assignment_status_code <> cp_new_status;

Line 1209: igs_fi_wav_std_pgms_pkg.update_row(

1205: FOR stdnt_wav_assgn_rec IN stdnt_wav_assgn_cur(p_v_fee_cal_type,p_n_fee_ci_seq_number,p_v_waiver_name,p_v_new_status) LOOP
1206:
1207: BEGIN
1208: --Callout to update the student Waiver Assignment Status.
1209: igs_fi_wav_std_pgms_pkg.update_row(
1210: x_rowid => stdnt_wav_assgn_rec.ROWID,
1211: x_waiver_student_id => stdnt_wav_assgn_rec.waiver_student_id,
1212: x_fee_cal_type => stdnt_wav_assgn_rec.fee_cal_type,
1213: x_fee_ci_sequence_number => stdnt_wav_assgn_rec.fee_ci_sequence_number,