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_CREDITS_ALL

Line 23: p_person_id IN igs_fi_credits_all.party_id%TYPE ,

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 ,
27: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,

Line 24: p_waiver_amount IN igs_fi_credits_all.amount%TYPE ,

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 ,
27: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
28: p_b_return_status OUT NOCOPY BOOLEAN

Line 25: p_currency_cd IN igs_fi_credits_all.currency_cd%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 ,
27: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
28: p_b_return_status OUT NOCOPY BOOLEAN
29: );

Line 26: p_gl_date IN igs_fi_credits_all.gl_date%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 ,
27: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
28: p_b_return_status OUT NOCOPY BOOLEAN
29: );
30:

Line 27: p_source_credit_id IN igs_fi_credits_all.credit_id%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 ,
27: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
28: p_b_return_status OUT NOCOPY BOOLEAN
29: );
30:
31: -- Procedure for enabling statement level logging

Line 68: p_person_id IN igs_fi_credits_all.party_id%TYPE ,

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 ,
72: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,

Line 69: p_waiver_amount IN igs_fi_credits_all.amount%TYPE ,

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 ,
72: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,
73: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,

Line 70: p_currency_cd IN igs_fi_credits_all.currency_cd%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 ,
72: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,
73: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
74: x_waiver_credit_id OUT NOCOPY NUMBER ,

Line 71: p_exchange_rate IN igs_fi_credits_all.exchange_rate%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 ,
72: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,
73: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
74: x_waiver_credit_id OUT NOCOPY NUMBER ,
75: x_waiver_adjustment_id OUT NOCOPY NUMBER

Line 72: p_gl_date IN igs_fi_credits_all.gl_date%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 ,
72: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,
73: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
74: x_waiver_credit_id OUT NOCOPY NUMBER ,
75: x_waiver_adjustment_id OUT NOCOPY NUMBER
76: ) AS

Line 73: p_source_credit_id IN igs_fi_credits_all.credit_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 ,
72: p_gl_date IN igs_fi_credits_all.gl_date%TYPE ,
73: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
74: x_waiver_credit_id OUT NOCOPY NUMBER ,
75: x_waiver_adjustment_id OUT NOCOPY NUMBER
76: ) AS
77: ------------------------------------------------------------------

Line 121: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;

117:
118: l_n_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
119: l_n_version_number igs_fi_balance_rules.version_number%TYPE;
120: l_n_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
121: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
122: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
123:
124: l_d_last_conversion_date DATE;
125:

Line 474: p_person_id IN igs_fi_credits_all.party_id%TYPE ,

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 ,
478: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,

Line 475: p_waiver_amount IN igs_fi_credits_all.amount%TYPE ,

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 ,
478: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
479: p_b_return_status OUT NOCOPY BOOLEAN

Line 476: p_currency_cd IN igs_fi_credits_all.currency_cd%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 ,
478: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
479: p_b_return_status OUT NOCOPY BOOLEAN
480: ) AS

Line 477: p_gl_date IN igs_fi_credits_all.gl_date%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 ,
478: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
479: p_b_return_status OUT NOCOPY BOOLEAN
480: ) AS
481: ------------------------------------------------------------------

Line 478: p_source_credit_id IN igs_fi_credits_all.credit_id%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 ,
478: p_source_credit_id IN igs_fi_credits_all.credit_id%TYPE ,
479: p_b_return_status OUT NOCOPY BOOLEAN
480: ) AS
481: ------------------------------------------------------------------
482: --Created by : Sanil Madathil, Oracle IDC

Line 510: cp_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

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

Line 522: FROM igs_fi_credits_all crd

518: ,crd.credit_id
519: ,crd.status
520: ,crd.amount
521: ,crd.unapplied_amount
522: FROM igs_fi_credits_all crd
523: WHERE crd.credit_id = cp_n_credit_id
524: AND crd.fee_cal_type = cp_v_fee_cal_type
525: AND crd.fee_ci_sequence_number = cp_n_fee_sequence_number
526: AND crd.waiver_name = cp_v_waiver_name;

Line 531: cp_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

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

Line 559: l_n_eligible_amount igs_fi_credits_all.amount%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;
560: l_n_wavadj_amt igs_fi_credits_all.amount%TYPE;
561: BEGIN
562:
563: log_to_fnd(p_v_module => 'validate_parameters',

Line 560: l_n_wavadj_amt igs_fi_credits_all.amount%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;
560: l_n_wavadj_amt igs_fi_credits_all.amount%TYPE;
561: BEGIN
562:
563: log_to_fnd(p_v_module => 'validate_parameters',
564: p_v_string => ' Entered Procedure validate_parameters: The input parameters are '||