DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on FND_PROFILE

Line 72: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

68: type varchar2_tbl is table of varchar2(1) index by binary_integer;
69: g_plan_ver_id_res_class_tbl varchar2_tbl;
70:
71: -- End cbs change
72: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
73: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_PLAN_MAINT_PVT';
74:
75:
76: -- 'P' VARCHAR2(15) := 'P';

Line 1817: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');

1813: RETURN;
1814: END IF;
1815:
1816: /* Added for bug 8708651 starts */
1817: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
1818: l_up_process_flag := PJI_UTILS.GET_SETUP_PARAMETER('UP_PROCESS_FLAG');
1819: /* Added for bug 8708651 ends */
1820:
1821: --#bug 5356051

Line 12696: IF nvl(FND_PROFILE.VALUE('PJI_GATHERSTATS_FACT'),'N') = 'Y' THEN -- Added for bug 11789673 Base bug 9824355

12692: If UPPD is submitted standalone, then gather stats is required.
12693: If UPPD is submitted from Launch process, gather stats is not required */
12694:
12695: if l_from_launch = 'N' then
12696: IF nvl(FND_PROFILE.VALUE('PJI_GATHERSTATS_FACT'),'N') = 'Y' THEN -- Added for bug 11789673 Base bug 9824355
12697: -- gather statistics for PJI metadata tables
12698: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
12699: tabname => 'PJI_FP_XBS_ACCUM_F',
12700: percent => 5,