APPS.OKC_CURRENCY_API dependencies on FND_PROFILE

Line 3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKC_CURRENCY_API AS
2: /* $Header: OKCPCURB.pls 120.1 2006/02/27 14:17:38 hvaladip noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: -- Function Get_OU_Currency ( Org_ID IN NUMBER )
6: -- Returns Currency code
7: -- Parameters - If Org_ID IS NULL, then determines the functional currency

Line 8: -- for the operating unit, using FND_Profile Org_ID.

4:
5: -- Function Get_OU_Currency ( Org_ID IN NUMBER )
6: -- Returns Currency code
7: -- Parameters - If Org_ID IS NULL, then determines the functional currency
8: -- for the operating unit, using FND_Profile Org_ID.
9:
10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11:
12: FUNCTION GET_OU_CURRENCY ( p_ORG_ID IN NUMBER )

Line 23: fnd_profile.get('ORG_ID',l_org_id);

19: Begin
20: l_org_id := p_org_id;
21:
22: IF l_org_id IS NULL then
23: fnd_profile.get('ORG_ID',l_org_id);
24: END IF;
25:
26: /****
27: commented to avoid OKX and performance issue

Line 106: fnd_profile.get('ORG_ID',l_org_id);

102:
103: l_org_id := p_org_id;
104:
105: IF p_org_id IS NULL then
106: fnd_profile.get('ORG_ID',l_org_id);
107: END IF;
108:
109: /*****
110: commented to avoid OKX and performance issue

Line 156: fnd_profile.get('ORG_ID',l_org_id);

152:
153: l_org_id := p_org_id;
154:
155: IF p_org_id IS NULL then
156: fnd_profile.get('ORG_ID',l_org_id);
157: END IF;
158:
159: /****
160: commented to avoid OKX and performance issue

Line 497: and the fnd_profile would be used.

493: -- l_curr_euro := gl_currency_api.get_euro_code; /* Bugfix 2256060 - This line is moved after checking the currency_type */
494:
495:
496: /* If the OKC Context is not set then Org_ID would be returned as NULL
497: and the fnd_profile would be used.
498: If the context returns -99, then get_ou_curr api will return NULL */
499:
500: -- commented out sysdate check for testing.
501: