APPS.ARW_CMREQ_COVER dependencies on FND_PROFILE

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

1: PACKAGE BODY arw_cmreq_cover AS
2: /* $Header: ARWCMRQB.pls 120.39.12010000.3 2008/09/03 06:42:03 naneja ship $ */
3:
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: FUNCTION ar_request_cm(
8: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
9: p_line_credits_flag IN ra_cm_requests.line_credits_flag%type,

Line 51: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;

47: l_total_line_amount number;
48: l_dispute_amount number;
49: l_url ra_cm_requests.url%TYPE;
50: l_status varchar2(255);
51: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;
52: /*Bug 5481525 variables to hold status of CM creation*/
53: l_credit_memo_id number;
54: l_result VARCHAR2(10);
55: l_threshold NUMBER;

Line 543: fnd_profile.get('AR_USE_OAM_IN_CMWF', l_profile_value);

539: END IF;
540: return('-1');
541: end if;
542: ELSE
543: fnd_profile.get('AR_USE_OAM_IN_CMWF', l_profile_value);
544: IF PG_DEBUG in ('Y', 'C') THEN
545: arp_util.debug('arw_cmreq_cover.ar_request_cm(-)' || l_profile_value);
546: END IF;
547: IF (l_profile_value = 'Y') Then

Line 751: IF NOT (nvl(fnd_profile.value('AR_USE_OAM_IN_CMWF'),'N') = 'Y' and p_batch_source_name is NULL ) THEN

747: /* 5041175 - obsoleting ar_transaction_pub and associated
748: routines. Replaced with inline sql logic to fetch
749: batch source */
750: /*6010707 As per doc when using AME the batch source name can be null*/
751: IF NOT (nvl(fnd_profile.value('AR_USE_OAM_IN_CMWF'),'N') = 'Y' and p_batch_source_name is NULL ) THEN
752: select batch_source_id
753: into l_batch_source_id
754: from ra_batch_sources
755: where name = p_batch_source_name