APPS.AR_CMGT_AGING dependencies on FND_PROFILE

Line 5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1: PACKAGE BODY ar_cmgt_aging AS
2: /* $Header: ARCMAGEB.pls 120.5 2006/06/01 05:56:26 kjoshi noship $ */
3:
4: --
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: pg_source_name VARCHAR2(30) := nvl(AR_CMGT_DATA_POINTS_PKG.g_source_name,'OCM');
8: pg_source_id VARCHAR2(45) := nvl(AR_CMGT_DATA_POINTS_PKG.g_source_id,-99);
9:

Line 227: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')

223: and parent_id = p_party_id
224: and effective_start_date <= l_as_of_date
225: and effective_end_date >= l_as_of_date
226: and hierarchy_type =
227: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
228: and pg_source_name <> 'LNS'
229: union
230: select p_party_id from dual
231: UNION

Line 370: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')

366: and parent_id = p_party_id
367: and effective_start_date <= l_as_of_date
368: and effective_end_date >= l_as_of_date
369: and hierarchy_type =
370: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
371: and pg_source_name <> 'LNS'
372: union
373: select p_party_id from dual
374: UNION

Line 494: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')

490: and parent_id = p_party_id
491: and effective_start_date <= l_as_of_date
492: and effective_end_date >= l_as_of_date
493: and hierarchy_type =
494: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
495: and pg_source_name <> 'LNS'
496: union
497: select p_party_id from dual
498: UNION

Line 637: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')

633: and parent_id = p_party_id
634: and effective_start_date <= l_as_of_date
635: and effective_end_date >= l_as_of_date
636: and hierarchy_type =
637: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
638: and pg_source_name <> 'LNS'
639: union
640: select p_party_id from dual
641: UNION