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 789: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),

785: debug( ' program_id='||profile_info.conc_program_id, MSG_LEVEL_DEBUG );
786: debug( ' user_id='||profile_info.user_id, MSG_LEVEL_DEBUG );
787: debug( ' use_inv_acct='||profile_info.use_inv_acct_for_cm_flag,
788: MSG_LEVEL_DEBUG );
789: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),
790: MSG_LEVEL_DEBUG );
791:
792: -- flex info
793: debug( ' nsegs='||to_char(flex_info.number_segments), MSG_LEVEL_DEBUG);

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

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

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

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

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

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

Line 1952: l_base_precision := ARP_GLOBAL.base_precision;

1948: BEGIN
1949:
1950: print_fcn_label( 'arp_auto_accounting.build_select_sql()+' );
1951:
1952: l_base_precision := ARP_GLOBAL.base_precision;
1953: l_base_min_acc_unit := nvl(ARP_GLOBAL.base_min_acc_unit,1);
1954:
1955: ------------------------------------------------------------------------
1956: -- Initialize building blocks

Line 1953: l_base_min_acc_unit := nvl(ARP_GLOBAL.base_min_acc_unit,1);

1949:
1950: print_fcn_label( 'arp_auto_accounting.build_select_sql()+' );
1951:
1952: l_base_precision := ARP_GLOBAL.base_precision;
1953: l_base_min_acc_unit := nvl(ARP_GLOBAL.base_min_acc_unit,1);
1954:
1955: ------------------------------------------------------------------------
1956: -- Initialize building blocks
1957: ------------------------------------------------------------------------

Line 5657: arp_global.msg_level := p_msg_level;

5653: --------------------------------------------------------------------------
5654: -- Set message level for debugging
5655: --------------------------------------------------------------------------
5656: system_info.msg_level := p_msg_level;
5657: arp_global.msg_level := p_msg_level;
5658:
5659: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()+ ' );
5660:
5661: --------------------------------------------------------------------------

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

6441:
6442: --
6443: -- Set message level for debugging
6444: --
6445: system_info.msg_level := arp_global.msg_level;
6446:
6447: debug( ' mode='||p_mode, MSG_LEVEL_DEBUG );
6448: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
6449: debug( ' customer_trx_id='||to_char(p_customer_trx_id), MSG_LEVEL_DEBUG );

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

6950:
6951: --
6952: -- Set message level for debugging
6953: --
6954: system_info.msg_level := arp_global.msg_level;
6955:
6956: debug( ' mode='||p_mode, MSG_LEVEL_DEBUG );
6957: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
6958: debug( ' customer_trx_id='||to_char(p_customer_trx_id), MSG_LEVEL_DEBUG );

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

7215: get_inv_item_ccids(profile_info,
7216: p_inv_item_id,
7217: '',
7218: l_ccid_rev, l_inv_item_type );
7219: debug( 'ORG_ID='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)||
7220: ' INV_ITEM_ID='||to_char(p_inv_item_id)||
7221: ' rev:'||to_char(l_ccid_rev) );
7222: end if;
7223: