[Home] [Help]
59: l_rows NUMBER;
60: BEGIN
61: debug('insert_term_contingencies()+');
62:
63: l_user_id := fnd_global.user_id;
64:
65: IF p_request_id IS NOT NULL
66: THEN
67: /* This is either invoice API or autoinvoice */
295: l_rows NUMBER;
296: BEGIN
297: debug('insert_credit_contingencies()+');
298:
299: l_user_id := fnd_global.user_id;
300:
301: IF p_request_id IS NOT NULL
302: THEN
303: /* This is either invoice API or autoinvoice */
519: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
520: debug(' p_mode : ' || p_mode);
521:
522: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
523: fnd_global.conc_request_id));
524:
525: IF (p_mode = 'RECORD') THEN
526:
527: INSERT INTO ar_reviewed_lines_gt
667: debug(' p_customer_trx_id : ' || p_customer_trx_id);
668: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
669:
670: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
671: fnd_global.conc_request_id));
672:
673: INSERT INTO ar_reviewed_lines_gt
674: (
675: customer_trx_line_id,
738: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
739: END IF;
740:
741: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
742: fnd_global.conc_request_id));
743:
744:
745: /* 4996493 - modified child to parent for parameter trx and line_ids
746: so that acceptance picks up the parent lines and any child lines
843: debug(' p_customer_trx_id : ' || p_customer_trx_id);
844: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
845:
846: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
847: fnd_global.conc_request_id));
848:
849: IF p_mode = 'NORMAL' THEN
850:
851: INSERT INTO ar_reviewed_lines_gt
1456:
1457: debug('copy_parent_contingencies()+');
1458: debug(' p_request_id : ' || p_request_id);
1459:
1460: l_user_id := fnd_global.user_id;
1461:
1462: /* 5513146 - Check for lines in interface table before
1463: executing the INSERT. */
1464: SELECT 1
1695: );
1696:
1697: debug('returned after the call to fun_rules_pub.apply_rule_bulk');
1698:
1699: l_user_id := fnd_global.user_id;
1700:
1701: /* As from R12 contingency_id replaces contingency_code as the unique
1702: identifier along with customer_trx_line_id, but remains part of the key
1703: so to avoid a case change we populate contingency_code with contingency_id
1904:
1905: debug('insert_contingencies_from_gt()+');
1906: debug(' p_request_id : ' || p_request_id);
1907:
1908: l_user_id := fnd_global.user_id;
1909:
1910: -- invoice creation api uses global temporary tables to accept
1911: -- input data as opposed to interface tables.
1912:
2012:
2013: debug('insert_contingencies_from_itf()+');
2014: debug( ' p_request_id : ' || p_request_id);
2015:
2016: l_user_id := fnd_global.user_id;
2017:
2018: -- now we are about to process the contingencies passed through the
2019: -- ar_interface_contingencies_all before we do that we have retrieve
2020: -- the context and using that determing the dynamic portion of
2125: debug('insert_deferred_lines()+');
2126: debug('p_request_id : ' || p_request_id);
2127: debug('p_customer_trx_line_id : ' || p_customer_trx_line_id);
2128:
2129: l_user_id := fnd_global.user_id;
2130:
2131: -- please note we are joining with ar_line_conts
2132: -- becuase we want to insert rows in the parent table only if
2133: -- there exists a row in the child table.
3109: p_customer_trx_line_id);
3110: END IF;
3111:
3112: l_sysdate := trunc(sysdate);
3113: l_user_id := fnd_global.user_id;
3114:
3115: IF (p_customer_trx_line_id IS NULL) THEN
3116:
3117: IF pg_debug IN ('Y', 'C') THEN
3189: END IF;
3190:
3191: -- if we reach here that means, we do care about this event.
3192:
3193: l_user_id := fnd_global.user_id;
3194:
3195: FOR cont_rec IN conts LOOP
3196:
3197: /* 5530037 - Revised logic to handle both
3234: DECODE(cont_rec.revrec_event_code, p_event_code,'Y',
3235: completed_flag),
3236: completed_by =
3237: DECODE(cont_rec.revrec_event_code, p_event_code,
3238: fnd_global.user_id, completed_by),
3239: reason_removal_date =
3240: DECODE(cont_rec.revrec_event_code, p_event_code,
3241: sysdate, reason_removal_date),
3242: last_updated_by = l_user_id,
4257: BEGIN
4258:
4259: debug('review_contingencies()+');
4260:
4261: l_last_updated_by := fnd_global.user_id;
4262: l_last_update_login := fnd_global.user_id;
4263:
4264: -- ***** should be converted into bulk fetch and
4265:
4258:
4259: debug('review_contingencies()+');
4260:
4261: l_last_updated_by := fnd_global.user_id;
4262: l_last_update_login := fnd_global.user_id;
4263:
4264: -- ***** should be converted into bulk fetch and
4265:
4266: FOR cont_rec IN contingencies LOOP
5966: debug('ar_revenue_management_pvt.periodic_sweeper +');
5967:
5968: retcode := SUCCESS;
5969:
5970: l_request_id := fnd_global.conc_request_id;
5971:
5972: /**allows to skip certain steps like rounding from the standard flow and
5973: process the same in bulk mode for better performance. */
5974: AR_RAAPI_UTIL.g_called_from := 'SWEEPER';