DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on FND_PROFILE

Line 5: p_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1: PACKAGE BODY PJI_PMV_ENGINE AS
2: /* $Header: PJIRX01B.pls 120.7.12010000.2 2008/08/08 10:41:56 arbandyo ship $ */
3:
4: g_SQL_Error_Msg VARCHAR2(3200);
5: p_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6:
7:
8: /*
9: ** Internal functions...

Line 1277: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');

1273: , p_View_BY VARCHAR2
1274: , p_Top_Organization_Name OUT NOCOPY VARCHAR2)
1275: AS
1276: l_Organization_Name VARCHAR2(240);
1277: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
1278: l_View_All_Org_Flag VARCHAR2(30);
1279:
1280: --Bug 4599990.
1281: l_top_organization_id per_security_profiles.organization_id%TYPE;

Line 1422: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');

1418:
1419: Procedure Convert_Organization(p_Top_Organization_ID NUMBER
1420: , p_View_BY VARCHAR2)
1421: AS
1422: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
1423: l_View_All_Org_Flag VARCHAR2(30);
1424: --Bug 4599990.
1425: l_top_organization_id per_security_profiles.organization_id%TYPE;
1426: BEGIN

Line 1564: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');

1560: */
1561:
1562: Procedure Convert_Organization(p_Top_Organization_ID NUMBER DEFAULT NULL)
1563: AS
1564: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
1565: l_View_All_Org_Flag VARCHAR2(30);
1566: l_Top_Organization_ID NUMBER:=p_Top_Organization_ID;
1567:
1568: --Bug 4599990.

Line 1693: l_Security_Profile_ID NUMBER:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');

1689:
1690: Procedure Convert_Operating_Unit(p_Operating_Unit_IDS VARCHAR2 DEFAULT NULL
1691: , p_View_BY VARCHAR2)
1692: AS
1693: l_Security_Profile_ID NUMBER:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');
1694: l_View_All_Org_Flag VARCHAR2(30);
1695: l_Dimension_List_Tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1696: BEGIN
1697: IF p_PA_DEBUG_MODE = 'Y' THEN