13997: CLOSE c1;
13998:
13999: IF l_rev_rec_req THEN
14000: IF PG_DEBUG = 'Y' THEN
14001: localdebug(' Executing Rev Rec - calling ARP_AUTO_RULE.create_distributions');
14002: END IF;
14003: l_sum_dist := ARP_AUTO_RULE.create_distributions
14004: ( p_commit => 'N',
14005: p_debug => 'N',
13999: IF l_rev_rec_req THEN
14000: IF PG_DEBUG = 'Y' THEN
14001: localdebug(' Executing Rev Rec - calling ARP_AUTO_RULE.create_distributions');
14002: END IF;
14003: l_sum_dist := ARP_AUTO_RULE.create_distributions
14004: ( p_commit => 'N',
14005: p_debug => 'N',
14006: p_trx_id => p_customer_trx_id);
14007: IF PG_DEBUG = 'Y' THEN
14100:
14101:
14102: IF l_rev_rec_req THEN
14103: IF PG_DEBUG = 'Y' THEN
14104: localdebug(' Executing Rev Rec - calling ARP_AUTO_RULE.create_distributions');
14105: END IF;
14106: x_sum_dist := ARP_AUTO_RULE.create_distributions
14107: ( p_commit => 'N',
14108: p_debug => 'N',
14102: IF l_rev_rec_req THEN
14103: IF PG_DEBUG = 'Y' THEN
14104: localdebug(' Executing Rev Rec - calling ARP_AUTO_RULE.create_distributions');
14105: END IF;
14106: x_sum_dist := ARP_AUTO_RULE.create_distributions
14107: ( p_commit => 'N',
14108: p_debug => 'N',
14109: p_trx_id => p_customer_trx_id);
14110: IF x_sum_dist < 0 THEN