DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on AR_DEFERRAL_REASONS

Line 178: ar_deferral_reasons dr

174:
175: CURSOR default_contingencies IS
176: SELECT id, contingency_id, revrec_event_code, expiration_days
177: FROM fun_rule_bulk_result_gt gt,
178: ar_deferral_reasons dr
179: WHERE gt.result_value = dr.contingency_id
180: AND revrec_event_code in ('INVOICING', 'CUSTOMER_ACCEPTANCE')
181: ORDER BY id, revrec_event_code DESC, expiration_days, creation_date DESC;
182:

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

355:
356: IF l_inserted_lines > 0 THEN
357: --Call AR API
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );
360: END IF;
361: ar_deferral_reasons_grp.default_reasons (
362: p_api_version => 1.0,
363: p_mode => 'OM',

Line 361: ar_deferral_reasons_grp.default_reasons (

357: --Call AR API
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );
360: END IF;
361: ar_deferral_reasons_grp.default_reasons (
362: p_api_version => 1.0,
363: p_mode => 'OM',
364: x_return_status => l_return_status,
365: x_msg_count => l_msg_count,

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

365: x_msg_count => l_msg_count,
366: x_msg_data => l_msg_data);
367:
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
370: END IF;
371:
372: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
373: --pick one pre-billing or post-billing contingency

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

368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
370: END IF;
371:
372: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
373: --pick one pre-billing or post-billing contingency
374:
375: --1. Pre-billing deferral reason has precedence over post-billing one
376: --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.