APPS.ARP_CACHE_UTIL dependencies on ARP_UTIL

Line 11: arp_util.debug('arp_cache_util.Refresh_Cache()+');

7:
8: BEGIN
9:
10: IF PG_DEBUG = 'Y' THEN
11: arp_util.debug('arp_cache_util.Refresh_Cache()+');
12: END IF;
13:
14: -- if the org_id has not changed, then do nothing, return.
15: -- arp_global.init_global is called in several places, so not

Line 23: arp_util.debug('Non Multi-Org; '||

19: IF (arp_trx_global.system_info.system_parameters.org_id is null
20: and ((substrb(userenv('CLIENT_INFO'),1,1) = ' ')
21: or (userenv('CLIENT_INFO') is null))) THEN
22: IF PG_DEBUG = 'Y' THEN
23: arp_util.debug('Non Multi-Org; '||
24: 'Trx Global org_id is null as well as CLIENT_INFO org');
25: END IF;
26:
27: IF arp_trx_global.system_info.system_parameters.set_of_books_id IS NOT NULL THEN

Line 29: arp_util.debug('Non Multi-Org and cache exists ');

25: END IF;
26:
27: IF arp_trx_global.system_info.system_parameters.set_of_books_id IS NOT NULL THEN
28: IF PG_DEBUG = 'Y' THEN
29: arp_util.debug('Non Multi-Org and cache exists ');
30: arp_util.debug('SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
31: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id);
32: arp_util.debug('Not Refreshing Cache');
33: END IF;

Line 30: arp_util.debug('SOB from arp_global is '|| arp_global.sysparam.set_of_books_id

26:
27: IF arp_trx_global.system_info.system_parameters.set_of_books_id IS NOT NULL THEN
28: IF PG_DEBUG = 'Y' THEN
29: arp_util.debug('Non Multi-Org and cache exists ');
30: arp_util.debug('SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
31: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id);
32: arp_util.debug('Not Refreshing Cache');
33: END IF;
34:

Line 32: arp_util.debug('Not Refreshing Cache');

28: IF PG_DEBUG = 'Y' THEN
29: arp_util.debug('Non Multi-Org and cache exists ');
30: arp_util.debug('SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
31: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id);
32: arp_util.debug('Not Refreshing Cache');
33: END IF;
34:
35: return;
36:

Line 44: arp_util.debug('Org from CLIENT_INFO matches Trx Global org');

40: and (substrb(userenv('CLIENT_INFO'),1,1) <> ' ')
41: and (pg_old_org_id =
42: to_number(substrb(userenv('CLIENT_INFO'),1,10)))) THEN
43: IF PG_DEBUG = 'Y' THEN
44: arp_util.debug('Org from CLIENT_INFO matches Trx Global org');
45: arp_util.debug(' Org from arp_global is ' || arp_global.sysparam.org_id
46: || ' , SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
47: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id);
48: arp_util.debug('Not Refreshing Cache');

Line 45: arp_util.debug(' Org from arp_global is ' || arp_global.sysparam.org_id

41: and (pg_old_org_id =
42: to_number(substrb(userenv('CLIENT_INFO'),1,10)))) THEN
43: IF PG_DEBUG = 'Y' THEN
44: arp_util.debug('Org from CLIENT_INFO matches Trx Global org');
45: arp_util.debug(' Org from arp_global is ' || arp_global.sysparam.org_id
46: || ' , SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
47: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id);
48: arp_util.debug('Not Refreshing Cache');
49: END IF;

Line 48: arp_util.debug('Not Refreshing Cache');

44: arp_util.debug('Org from CLIENT_INFO matches Trx Global org');
45: arp_util.debug(' Org from arp_global is ' || arp_global.sysparam.org_id
46: || ' , SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
47: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id);
48: arp_util.debug('Not Refreshing Cache');
49: END IF;
50: return;
51: END IF;
52:

Line 57: arp_util.debug('Refreshing Cache');

53: -- Otherwise cache does not exist or
54: -- Cache is incorrect, so need to be refreshed
55:
56: IF PG_DEBUG = 'Y' THEN
57: arp_util.debug('Refreshing Cache');
58: END IF;
59:
60: ARP_TRX_GLOBAL.init;
61: ARP_PROCESS_CREDIT_UTIL.init;

Line 82: arp_util.debug('arp_cache_util.Refresh_Cache()-');

78: -- AR_MC_INFO.init; -- obsolete
79: --5885313 set variable to current org
80: PG_OLD_ORG_ID := arp_trx_global.system_info.system_parameters.org_id;
81: IF PG_DEBUG = 'Y' THEN
82: arp_util.debug('arp_cache_util.Refresh_Cache()-');
83: END IF;
84:
85: END refresh_cache;
86: