[Home] [Help]
398: EXIT WHEN c_credit_amnt%NOTFOUND;
399: l_message_name := NULL ;
400: --invoke the common funtion for exclusion rules .If this function returns 1 then do not include this amount for the charges.
401: --5 TO MAKE IT NOT l_boolean
402: IF NOT igs_fi_prc_balances.check_exclusion_rules (p_balance_type => 'HOLDS',
403: p_source_type => 'CREDIT',
404: p_balance_date => TRUNC(l_credit_amnt_rec.effective_date),
405: p_source_id => l_credit_amnt_rec.credit_id ,
406: p_balance_rule_id => l_balance_rule_id,
476:
477: EXIT WHEN c_invoice_amnt%NOTFOUND;
478: --invoke the common funtion for exclusion rules .If this function returns 1 then do not include this amount for the charges.
479: l_message_name := NULL;
480: IF NOT igs_fi_prc_balances.check_exclusion_rules(p_balance_type => 'HOLDS',
481: p_source_type => 'CHARGE',
482: p_balance_date => TRUNC(l_invoice_amnt_rec.invoice_creation_date),
483: p_source_id => l_invoice_amnt_rec.Invoice_id ,
484: p_balance_rule_id => l_balance_rule_id,
1907: -- Each of the above credit record is checked for exclusion rules by calling the common function for exclusion
1908: -- Use a local variable to sum up the non-excluded credits of the person
1909: --5
1910: l_message_name := NULL;
1911: IF NOT igs_fi_prc_balances.check_exclusion_rules (p_balance_type => 'HOLDS',
1912: P_source_type => 'CREDIT',
1913: P_balance_date => TRUNC(l_credit_amount_rec.effective_date),
1914: P_source_id => l_credit_amount_rec.credit_id,
1915: p_balance_rule_id => l_balance_rule_id,
1978: FETCH c_total_balance INTO l_total_balance_rec;
1979: EXIT when c_total_balance%NOTFOUND ;
1980: --6
1981: l_message_name := NULL;
1982: IF NOT igs_fi_prc_balances.check_exclusion_rules ( p_balance_type => 'HOLDS',
1983: P_source_type => 'CHARGE',
1984: P_balance_date => TRUNC(l_total_balance_rec.invoice_creation_date),
1985: P_source_id => l_total_balance_rec.invoice_id ,
1986: p_balance_rule_id => l_balance_rule_id,