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_WAIVERS_API_PUB dependencies on IGS_FI_WAIVER_PGMS

Line 22: p_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE ,

18: -- Procedure for validating all inbound parameters to API
19: PROCEDURE validate_parameters(
20: p_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE ,
21: p_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE ,
22: p_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE ,
23: p_person_id IN igs_fi_credits_all.party_id%TYPE ,
24: p_waiver_amount IN igs_fi_credits_all.amount%TYPE ,
25: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE ,
26: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,

Line 40: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE

36:
37: CURSOR c_waiver_pgms (
38: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
39: cp_n_fee_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
40: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE
41: ) IS
42: SELECT fwp.fee_cal_type
43: ,fwp.fee_ci_sequence_number
44: ,fwp.waiver_name

Line 51: FROM igs_fi_waiver_pgms fwp

47: ,fwp.credit_type_id
48: ,fwp.target_fee_type
49: ,fwp.adjustment_fee_type
50: ,fwp.waiver_mode_code
51: FROM igs_fi_waiver_pgms fwp
52: WHERE fwp.fee_cal_type = cp_v_fee_cal_type
53: AND fwp.fee_ci_sequence_number = cp_n_fee_sequence_number
54: AND fwp.waiver_name = cp_v_waiver_name;
55:

Line 67: p_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE ,

63: x_msg_count OUT NOCOPY NUMBER ,
64: x_msg_data OUT NOCOPY VARCHAR2 ,
65: p_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE ,
66: p_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE ,
67: p_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE ,
68: p_person_id IN igs_fi_credits_all.party_id%TYPE ,
69: p_waiver_amount IN igs_fi_credits_all.amount%TYPE ,
70: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE ,
71: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE ,

Line 473: p_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE ,

469:
470: PROCEDURE validate_parameters(
471: p_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE ,
472: p_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE ,
473: p_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE ,
474: p_person_id IN igs_fi_credits_all.party_id%TYPE ,
475: p_waiver_amount IN igs_fi_credits_all.amount%TYPE ,
476: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE ,
477: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,

Line 513: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE

509: CURSOR c_credits (
510: cp_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
511: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
512: cp_n_fee_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
513: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE
514: ) IS
515: SELECT crd.fee_cal_type
516: ,crd.fee_ci_sequence_number
517: ,crd.waiver_name

Line 534: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE

530: CURSOR c_waiver_adj_appl (
531: cp_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
532: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
533: cp_n_fee_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
534: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE
535: ) IS
536: SELECT appl.amount_applied
537: FROM igs_fi_applications appl,
538: igs_fi_inv_int_all inv