APPS.ARP_CACHE_UTIL dependencies on ARP_GLOBAL

Line 15: -- arp_global.init_global is called in several places, so not

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
16: -- relying on sysparam record type, but checking if the all other
17: -- cache/global variables are refreshed
18:
19: IF (arp_trx_global.system_info.system_parameters.org_id is null

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 38: --5885313 compare with current operating unit because ARP_GLOBal itself initialized arp_trx_global

34:
35: return;
36:
37: END IF;
38: --5885313 compare with current operating unit because ARP_GLOBal itself initialized arp_trx_global
39: ELSIF ( (arp_trx_global.system_info.system_parameters.org_id is not null)
40: and (substrb(userenv('CLIENT_INFO'),1,1) <> ' ')
41: and (pg_old_org_id =
42: to_number(substrb(userenv('CLIENT_INFO'),1,10)))) THEN

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 46: || ' , SOB from arp_global is '|| arp_global.sysparam.set_of_books_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;
50: return;