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_CA_INST

Line 20: p_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE ,

16: g_pkg_name CONSTANT VARCHAR2(30) := 'igs_fi_waivers_api_pub';
17:
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 ,

Line 21: p_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE ,

17:
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 ,

Line 38: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

34: p_v_string IN VARCHAR2
35: );
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

Line 39: cp_n_fee_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

35: );
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

Line 65: p_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE ,

61: p_commit IN VARCHAR2 ,
62: x_return_status OUT NOCOPY VARCHAR2 ,
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 ,

Line 66: p_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE ,

62: x_return_status OUT NOCOPY VARCHAR2 ,
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 ,

Line 471: p_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE ,

467: );
468: END create_manual_waivers;
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 ,

Line 472: p_fee_ci_seq_number IN igs_ca_inst_all.sequence_number%TYPE ,

468: END create_manual_waivers;
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 ,

Line 511: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

507: rec_c_waiver_pgms c_waiver_pgms%ROWTYPE;
508:
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

Line 512: cp_n_fee_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

508:
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

Line 532: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

528: rec_c_credits c_credits%ROWTYPE;
529:
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

Line 533: cp_n_fee_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

529:
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,

Line 554: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

550: l_b_validation_success BOOLEAN;
551: l_b_chr_err_account NUMBER;
552:
553: l_v_message_name fnd_new_messages.message_name%TYPE;
554: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
555: l_v_ld_ci_seq_number igs_ca_inst.sequence_number%TYPE;
556: l_v_closing_status gl_period_statuses.closing_status%TYPE;
557: l_v_return_status VARCHAR2(1);
558:

Line 555: l_v_ld_ci_seq_number igs_ca_inst.sequence_number%TYPE;

551: l_b_chr_err_account NUMBER;
552:
553: l_v_message_name fnd_new_messages.message_name%TYPE;
554: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
555: l_v_ld_ci_seq_number igs_ca_inst.sequence_number%TYPE;
556: l_v_closing_status gl_period_statuses.closing_status%TYPE;
557: l_v_return_status VARCHAR2(1);
558:
559: l_n_eligible_amount igs_fi_credits_all.amount%TYPE;