DBA Data[Home] [Help]

APPS.ARP_AUTO_ACCOUNTING dependencies on ARP_GLOBAL

Line 12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;

8: --
9: -- Linefeed character
10: --
11: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: YES CONSTANT VARCHAR2(1) := arp_global.YES;
15: NO CONSTANT VARCHAR2(1) := arp_global.NO;
16:

Line 14: YES CONSTANT VARCHAR2(1) := arp_global.YES;

10: --
11: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: YES CONSTANT VARCHAR2(1) := arp_global.YES;
15: NO CONSTANT VARCHAR2(1) := arp_global.NO;
16:
17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;

Line 15: NO CONSTANT VARCHAR2(1) := arp_global.NO;

11: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
12: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
13:
14: YES CONSTANT VARCHAR2(1) := arp_global.YES;
15: NO CONSTANT VARCHAR2(1) := arp_global.NO;
16:
17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;

Line 17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;

13:
14: YES CONSTANT VARCHAR2(1) := arp_global.YES;
15: NO CONSTANT VARCHAR2(1) := arp_global.NO;
16:
17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
20: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
21: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEVELOP;

Line 18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;

14: YES CONSTANT VARCHAR2(1) := arp_global.YES;
15: NO CONSTANT VARCHAR2(1) := arp_global.NO;
16:
17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
20: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
21: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEVELOP;
22:

Line 19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;

15: NO CONSTANT VARCHAR2(1) := arp_global.NO;
16:
17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
20: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
21: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEVELOP;
22:
23: MAX_CURSOR_CACHE_SIZE CONSTANT BINARY_INTEGER := 20;

Line 20: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;

16:
17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
20: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
21: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEVELOP;
22:
23: MAX_CURSOR_CACHE_SIZE CONSTANT BINARY_INTEGER := 20;
24: MAX_SEGMENT_CACHE_SIZE CONSTANT BINARY_INTEGER := 1000;

Line 21: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEVELOP;

17: MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_BASIC;
18: MSG_LEVEL_TIMING CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_TIMING;
19: MSG_LEVEL_DEBUG CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG;
20: MSG_LEVEL_DEBUG2 CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEBUG2;
21: MSG_LEVEL_DEVELOP CONSTANT BINARY_INTEGER := arp_global.MSG_LEVEL_DEVELOP;
22:
23: MAX_CURSOR_CACHE_SIZE CONSTANT BINARY_INTEGER := 20;
24: MAX_SEGMENT_CACHE_SIZE CONSTANT BINARY_INTEGER := 1000;
25: MAX_ARRAY_SIZE CONSTANT BINARY_INTEGER := 1000;

Line 34: G_MAX_DATE CONSTANT DATE:= arp_global.G_MAX_DATE;

30: MAX_HASH_CACHE_SIZE CONSTANT BINARY_INTEGER := 4000;
31: HASH_START CONSTANT NUMBER := 16384;
32: HASH_MAX CONSTANT NUMBER := 1000000;
33:
34: G_MAX_DATE CONSTANT DATE:= arp_global.G_MAX_DATE;
35: G_MIN_DATE CONSTANT DATE:= to_date('01-01-1952','DD-MM-YYYY');
36: G_SYS_DATE CONSTANT DATE:= TRUNC(SYSDATE);
37: -- This record holds general information used by autoaccounting and
38: -- credit memo module. Passed as argument to most functions/procs.

Line 791: IF(arp_global.sysparam.org_id IS NOT NULL) THEN

787: debug( ' use_inv_acct='||profile_info.use_inv_acct_for_cm_flag,
788: MSG_LEVEL_DEBUG );
789:
790: /*Bug 8640674*/
791: IF(arp_global.sysparam.org_id IS NOT NULL) THEN
792: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),
793: MSG_LEVEL_DEBUG );
794: END IF;
795:

Line 792: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),

788: MSG_LEVEL_DEBUG );
789:
790: /*Bug 8640674*/
791: IF(arp_global.sysparam.org_id IS NOT NULL) THEN
792: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),
793: MSG_LEVEL_DEBUG );
794: END IF;
795:
796: -- flex info

Line 927: AND ad.org_id = NVL(arp_global.sysparam.org_id, ad.org_id)

923: FROM
924: ra_account_default_segments ads,
925: ra_account_defaults ad
926: WHERE ad.gl_default_id = ads.gl_default_id
927: AND ad.org_id = NVL(arp_global.sysparam.org_id, ad.org_id)
928: AND ad.type in
929: (
930: 'REV', 'REC', 'FREIGHT', 'TAX', 'UNBILL', 'UNEARN', 'SUSPENSE'
931: )

Line 1463: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)));

1459:
1460: p_ccid_rev := -1;
1461: p_inv_item_type := NULL;
1462: t_warehouse_id := nvl(p_warehouse_id,
1463: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)));
1464: BEGIN
1465: --
1466: -- see if available in cache
1467: --

Line 1663: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id))) --Bug#1639334

1659: AND t.agreement_id = a.agreement_id(+)
1660: AND l.inventory_item_id = i.inventory_item_id(+)
1661: AND i.organization_id(+)
1662: = nvl(p_warehouse_id,
1663: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id))) --Bug#1639334
1664: AND i.category_set_id(+) = 1
1665: AND to_char(nvl(i.category_id, -1)) = c.value1
1666: AND nvl(a.agreement_type_code, -1) = nvl(c.value2 , -1);
1667:

Line 1957: l_base_precision := ARP_GLOBAL.base_precision;

1953: BEGIN
1954:
1955: print_fcn_label( 'arp_auto_accounting.build_select_sql()+' );
1956:
1957: l_base_precision := ARP_GLOBAL.base_precision;
1958:
1959: /* 9222866 - this variable used as a literal in dynamic sql.
1960: so the value NULL must be represented as 'NULL' and numeric
1961: values returned as themselves. */

Line 1964: l_base_min_acc_unit := NVL(TO_CHAR(ARP_GLOBAL.base_min_acc_unit),'');

1960: so the value NULL must be represented as 'NULL' and numeric
1961: values returned as themselves. */
1962:
1963: -- Bug 15939049
1964: l_base_min_acc_unit := NVL(TO_CHAR(ARP_GLOBAL.base_min_acc_unit),'');
1965: l_base_min_acc_unit := 'to_number('''||l_base_min_acc_unit||''')';
1966:
1967: ------------------------------------------------------------------------
1968: -- Initialize building blocks

Line 5722: arp_global.msg_level := p_msg_level;

5718: --------------------------------------------------------------------------
5719: -- Set message level for debugging
5720: --------------------------------------------------------------------------
5721: system_info.msg_level := p_msg_level;
5722: arp_global.msg_level := p_msg_level;
5723:
5724: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()+ ' );
5725:
5726: --------------------------------------------------------------------------

Line 6553: system_info.msg_level := arp_global.msg_level;

6549:
6550: --
6551: -- Set message level for debugging
6552: --
6553: system_info.msg_level := arp_global.msg_level;
6554:
6555: debug( ' mode='||p_mode, MSG_LEVEL_DEBUG );
6556: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
6557: debug( ' customer_trx_id='||to_char(p_customer_trx_id), MSG_LEVEL_DEBUG );

Line 7062: system_info.msg_level := arp_global.msg_level;

7058:
7059: --
7060: -- Set message level for debugging
7061: --
7062: system_info.msg_level := arp_global.msg_level;
7063:
7064: debug( ' mode='||p_mode, MSG_LEVEL_DEBUG );
7065: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
7066: debug( ' customer_trx_id='||to_char(p_customer_trx_id), MSG_LEVEL_DEBUG );

Line 7327: debug( 'ORG_ID='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)||

7323: get_inv_item_ccids(profile_info,
7324: p_inv_item_id,
7325: '',
7326: l_ccid_rev, l_inv_item_type );
7327: debug( 'ORG_ID='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)||
7328: ' INV_ITEM_ID='||to_char(p_inv_item_id)||
7329: ' rev:'||to_char(l_ccid_rev) );
7330: end if;
7331: