DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_PROFILE

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

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

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

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

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

3954: savepoint process_proj_sum_conc;
3955: ----------------------------------------------------------------------------------------
3956: -- Added If condition for Bug 5999999
3957:
3958: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
3959:
3960: l_request_id:=submit_request(l_project_id);
3961: if (FND_CONCURRENT.WAIT_FOR_REQUEST (
3962: l_request_id,

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

4196: savepoint process_proj_sum_conc;
4197: ----------------------------------------------------------------------------------------
4198: -- Added If condition for Bug 5999999
4199:
4200: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
4201:
4202: l_request_id:=submit_request(l_project_id);
4203: if (FND_CONCURRENT.WAIT_FOR_REQUEST (
4204: l_request_id,