APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_WAIVER_PGMS

Line 41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

37:
38: PROCEDURE call_charges_api( p_n_person_id IN hz_parties.party_id%TYPE,
39: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
40: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 214: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

210:
211: PROCEDURE call_credits_api(p_n_person_id IN hz_parties.party_id%TYPE,
212: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
213: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
214: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
215: p_n_credit_type_id IN igs_fi_credits.credit_id%TYPE,
216: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
217: p_n_waiver_amt IN NUMBER,
218: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 470: CURSOR cur_waiver_prg_attr(cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,

466: AND APPL2.AMOUNT_APPLIED = - APPL.AMOUNT_APPLIED)
467: ORDER BY appl.application_id;
468:
469: --Cursor to obtain the waiver program attributes.
470: CURSOR cur_waiver_prg_attr(cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
471: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
472: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
473: SELECT fwp.fee_cal_type,
474: fwp.fee_ci_sequence_number,

Line 471: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

467: ORDER BY appl.application_id;
468:
469: --Cursor to obtain the waiver program attributes.
470: CURSOR cur_waiver_prg_attr(cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
471: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
472: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
473: SELECT fwp.fee_cal_type,
474: fwp.fee_ci_sequence_number,
475: fwp.waiver_name,

Line 472: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS

468:
469: --Cursor to obtain the waiver program attributes.
470: CURSOR cur_waiver_prg_attr(cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
471: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
472: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
473: SELECT fwp.fee_cal_type,
474: fwp.fee_ci_sequence_number,
475: fwp.waiver_name,
476: fwp.credit_type_id,

Line 479: FROM igs_fi_waiver_pgms fwp

475: fwp.waiver_name,
476: fwp.credit_type_id,
477: fwp.target_fee_type,
478: fwp.adjustment_fee_type
479: FROM igs_fi_waiver_pgms fwp
480: WHERE fwp.fee_cal_type = cp_fee_cal_type
481: AND fwp.fee_ci_sequence_number = cp_fee_ci_sequence_number
482: AND fwp.waiver_name = cp_waiver_name;
483:

Line 855: FROM igs_fi_waiver_pgms fwp

851: SELECT fwp.fee_cal_type,
852: fwp.fee_ci_sequence_number,
853: fwp.waiver_name,
854: fwp.waiver_method_code
855: FROM igs_fi_waiver_pgms fwp
856: WHERE fwp.target_fee_type = cp_v_fee_type
857: AND fwp.fee_cal_type = cp_v_fee_cal_type
858: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq_number
859: AND fwp.waiver_method_code = 'COMP_RULE';

Line 862: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE,

858: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq_number
859: AND fwp.waiver_method_code = 'COMP_RULE';
860: --Cursor to Check whether student Assignment exists for waiver Record
861: CURSOR cur_wav_stud_assg_rec_exists(cp_n_person_id hz_parties.party_id%TYPE,
862: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE,
863: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
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,

Line 881: p_v_string => 'Before looping the IGS_FI_WAIVER_PGMS table for waiver programs');

877: l_b_return_flag BOOLEAN;
878: BEGIN
879: l_b_return_flag := FALSE;
880: log_to_fnd(p_v_module => 'check_stdnt_wav_assignment',
881: p_v_string => 'Before looping the IGS_FI_WAIVER_PGMS table for waiver programs');
882: /**
883: Logging of all the Input Parameters
884: */
885: log_to_fnd(p_v_module => 'check_stdnt_wav_assignment',

Line 980: FROM igs_fi_waiver_pgms pgms

976: ******************************************************************/
977: --Cursor to select the waiver program to be rolled over
978: CURSOR cur_waiver_pgms (cp_rollover_rowid VARCHAR2) IS
979: SELECT pgms.*
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,

Line 1000: FROM igs_fi_waiver_pgms

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
1001: WHERE waiver_name = cp_v_waiver_name
1002: AND fee_cal_type = cp_v_fee_cal_type
1003: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
1004:

Line 1078: igs_fi_waiver_pgms_pkg.insert_row(x_rowid => l_rowid,

1074: log_to_fnd(p_v_module => 'roll_over_wav_assign',
1075: p_v_string => 'After The Check for the Fee Types Validation');
1076: --Rollover the waiver program to the destination calendar.
1077: l_rowid := null;
1078: igs_fi_waiver_pgms_pkg.insert_row(x_rowid => l_rowid,
1079: x_fee_cal_type => l_cur_waiver_pgms.fee_cal_type,
1080: x_fee_ci_sequence_number => p_n_dest_fee_ci_seq_number,
1081: x_waiver_name => l_cur_waiver_pgms.waiver_name,
1082: x_waiver_desc => l_cur_waiver_pgms.waiver_desc,