APPS.PA_RES_LIST_UPGRADE_PKG dependencies on FND_PROFILE

Line 12: and resource_list_id <> nvl(FND_PROFILE.VALUE('PA_FORECAST_RESOURCE_LIST'), -99);

8: IS
9:
10: cursor get_res_list_csr is
11: select RESOURCE_LIST_ID from pa_resource_lists where migration_code is null
12: and resource_list_id <> nvl(FND_PROFILE.VALUE('PA_FORECAST_RESOURCE_LIST'), -99);
13:
14: tbl_res_id_list_tbl PA_PLSQL_DATATYPES.IdTabTyp;
15:
16: l_count NUMBER;

Line 29: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

25: BEGIN
26:
27: x_msg_count := 0;
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
30:
31: IF l_debug_mode = 'Y' THEN
32: pa_debug.set_curr_function( p_function => 'RES_LIST_PLAN_LIST_WHEN_NULL',
33: p_debug_mode => l_debug_mode );

Line 337: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

333:
334: x_msg_count := 0;
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: pa_debug.init_err_stack('PA_RES_LIST_UPGRADE_PKG.RES_LIST_TO_PLAN_RES_LIST');
337: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
338: l_debug_mode := NVL(l_debug_mode, 'Y');
339: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
340: --dbms_output.put_line('R2');
341: IF l_debug_mode = 'Y' THEN