DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on AR_DEFERRAL_REASONS

Line 168: ar_deferral_reasons dr

164:
165: CURSOR default_contingencies IS
166: SELECT id, contingency_id, revrec_event_code, expiration_days
167: FROM fun_rule_bulk_result_gt gt,
168: ar_deferral_reasons dr
169: WHERE gt.result_value = dr.contingency_id
170: AND revrec_event_code in ('INVOICING', 'CUSTOMER_ACCEPTANCE')
171: ORDER BY id, revrec_event_code DESC, expiration_days, creation_date DESC;
172:

Line 321: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );

317:
318: IF l_inserted_lines > 0 THEN
319: --Call AR API
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );
322: END IF;
323: ar_deferral_reasons_grp.default_reasons (
324: p_api_version => 1.0,
325: p_mode => 'OM',

Line 323: ar_deferral_reasons_grp.default_reasons (

319: --Call AR API
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );
322: END IF;
323: ar_deferral_reasons_grp.default_reasons (
324: p_api_version => 1.0,
325: p_mode => 'OM',
326: x_return_status => l_return_status,
327: x_msg_count => l_msg_count,

Line 331: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );

327: x_msg_count => l_msg_count,
328: x_msg_data => l_msg_data);
329:
330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
332: END IF;
333:
334: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
335: --pick one pre-billing or post-billing contingency

Line 334: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes

330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
332: END IF;
333:
334: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
335: --pick one pre-billing or post-billing contingency
336:
337: --1. Pre-billing deferral reason has precedence over post-billing one
338: --2. If there are two pre-billing deferral reasons(or two post-blling without prebilling), we pick the one that has less number of expiration days.