DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_PROFILE

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

9: g_package_name VARCHAR2(100) := 'PJI_FM_XBS_ACCUM_MAINT';
10: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_XBS_ACCUM_MAINT';
11: g_update_num_rows_limit NUMBER := 1; -- 1000;
12: g_smart_rows_deleted NUMBER :=0; --maintains the number of rows deleted in delete smart slice api
13: g_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
14: g_deffered_mode VARCHAR2(1) :='N';
15: g_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: Invalid_Excep Exception ;
17:

Line 127: IF NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N') = 'Y' THEN

123: PROCEDURE debug_plan_lines
124: IS
125: BEGIN
126:
127: IF NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N') = 'Y' THEN
128:
129: INSERT INTO pji_fm_extr_plan_lines_debug
130: (
131: PROJECT_ID ,

Line 4335: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN

4331: savepoint Update_project_pub; -- Added for Bug 14365759
4332: ----------------------------------------------------------------------------------------
4333: -- Added If condition for Bug 5999999
4334:
4335: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
4336:
4337: l_request_id:=submit_request(l_project_id);
4338: if (FND_CONCURRENT.WAIT_FOR_REQUEST (
4339: l_request_id,

Line 4578: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN

4574: savepoint Update_project_pub; -- Added for Bug 14365759
4575: ----------------------------------------------------------------------------------------
4576: -- Added If condition for Bug 5999999
4577:
4578: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
4579:
4580: l_request_id:=submit_request(l_project_id);
4581: if (FND_CONCURRENT.WAIT_FOR_REQUEST (
4582: l_request_id,