DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on FND_GLOBAL

Line 63: l_user_id := fnd_global.user_id;

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 */

Line 281: l_user_id := fnd_global.user_id;

277: l_rows NUMBER;
278: BEGIN
279: debug('insert_credit_contingencies()+');
280:
281: l_user_id := fnd_global.user_id;
282:
283: IF p_request_id IS NOT NULL
284: THEN
285: /* This is either invoice API or autoinvoice */

Line 487: fnd_global.conc_request_id));

483: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
484: debug(' p_mode : ' || p_mode);
485:
486: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
487: fnd_global.conc_request_id));
488:
489: IF (p_mode = 'RECORD') THEN
490:
491: INSERT INTO ar_reviewed_lines_gt

Line 617: fnd_global.conc_request_id));

613: debug(' p_customer_trx_id : ' || p_customer_trx_id);
614: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
615:
616: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
617: fnd_global.conc_request_id));
618:
619: INSERT INTO ar_reviewed_lines_gt
620: (
621: customer_trx_line_id,

Line 688: fnd_global.conc_request_id));

684: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
685: END IF;
686:
687: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
688: fnd_global.conc_request_id));
689:
690:
691: /* 4996493 - modified child to parent for parameter trx and line_ids
692: so that acceptance picks up the parent lines and any child lines

Line 793: fnd_global.conc_request_id));

789: debug(' p_customer_trx_id : ' || p_customer_trx_id);
790: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
791:
792: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
793: fnd_global.conc_request_id));
794:
795: IF p_mode = 'NORMAL' THEN
796:
797: INSERT INTO ar_reviewed_lines_gt

Line 1388: l_user_id := fnd_global.user_id;

1384:
1385: debug('copy_parent_contingencies()+');
1386: debug(' p_request_id : ' || p_request_id);
1387:
1388: l_user_id := fnd_global.user_id;
1389:
1390: /* 5513146 - Check for lines in interface table before
1391: executing the INSERT. */
1392: SELECT 1

Line 1608: l_user_id := fnd_global.user_id;

1604: );
1605:
1606: debug('returned after the call to fun_rules_pub.apply_rule_bulk');
1607:
1608: l_user_id := fnd_global.user_id;
1609:
1610: /* As from R12 contingency_id replaces contingency_code as the unique
1611: identifier along with customer_trx_line_id, but remains part of the key
1612: so to avoid a case change we populate contingency_code with contingency_id

Line 1804: l_user_id := fnd_global.user_id;

1800:
1801: debug('insert_contingencies_from_gt()+');
1802: debug(' p_request_id : ' || p_request_id);
1803:
1804: l_user_id := fnd_global.user_id;
1805:
1806: -- invoice creation api uses global temporary tables to accept
1807: -- input data as opposed to interface tables.
1808:

Line 1907: l_user_id := fnd_global.user_id;

1903:
1904: debug('insert_contingencies_from_itf()+');
1905: debug( ' p_request_id : ' || p_request_id);
1906:
1907: l_user_id := fnd_global.user_id;
1908:
1909: -- now we are about to process the contingencies passed through the
1910: -- ar_interface_contingencies_all before we do that we have retrieve
1911: -- the context and using that determing the dynamic portion of

Line 2015: l_user_id := fnd_global.user_id;

2011: debug('insert_deferred_lines()+');
2012: debug('p_request_id : ' || p_request_id);
2013: debug('p_customer_trx_line_id : ' || p_customer_trx_line_id);
2014:
2015: l_user_id := fnd_global.user_id;
2016:
2017: -- please note we are joining with ar_line_conts
2018: -- becuase we want to insert rows in the parent table only if
2019: -- there exists a row in the child table.

Line 2966: l_user_id := fnd_global.user_id;

2962: p_customer_trx_line_id);
2963: END IF;
2964:
2965: l_sysdate := trunc(sysdate);
2966: l_user_id := fnd_global.user_id;
2967:
2968: IF (p_customer_trx_line_id IS NULL) THEN
2969:
2970: IF pg_debug IN ('Y', 'C') THEN

Line 3046: l_user_id := fnd_global.user_id;

3042: END IF;
3043:
3044: -- if we reach here that means, we do care about this event.
3045:
3046: l_user_id := fnd_global.user_id;
3047:
3048: FOR cont_rec IN conts LOOP
3049:
3050: /* 5530037 - Revised logic to handle both

Line 3091: fnd_global.user_id, completed_by),

3087: DECODE(cont_rec.revrec_event_code, p_event_code,'Y',
3088: completed_flag),
3089: completed_by =
3090: DECODE(cont_rec.revrec_event_code, p_event_code,
3091: fnd_global.user_id, completed_by),
3092: reason_removal_date =
3093: DECODE(cont_rec.revrec_event_code, p_event_code,
3094: sysdate, reason_removal_date),
3095: last_updated_by = l_user_id,

Line 4121: l_last_updated_by := fnd_global.user_id;

4117: BEGIN
4118:
4119: debug('review_contingencies()+');
4120:
4121: l_last_updated_by := fnd_global.user_id;
4122: l_last_update_login := fnd_global.user_id;
4123:
4124: -- ***** should be converted into bulk fetch and
4125:

Line 4122: l_last_update_login := fnd_global.user_id;

4118:
4119: debug('review_contingencies()+');
4120:
4121: l_last_updated_by := fnd_global.user_id;
4122: l_last_update_login := fnd_global.user_id;
4123:
4124: -- ***** should be converted into bulk fetch and
4125:
4126: FOR cont_rec IN contingencies LOOP

Line 5785: l_request_id := fnd_global.conc_request_id;

5781: debug('ar_revenue_management_pvt.periodic_sweeper +');
5782:
5783: retcode := SUCCESS;
5784:
5785: l_request_id := fnd_global.conc_request_id;
5786:
5787: FOR morgs in cur_orgs
5788: LOOP
5789: mo_global.set_policy_context('S',morgs.org_id);