APPS.PA_ROLE_PROFILES_PUB dependencies on FND_PROFILE

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

37: l_return_status VARCHAR2(1);
38: l_prev_profile_id NUMBER := NULL;
39: l_msg_index_out NUMBER := 0;
40: l_end_date DATE := NULL;
41: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
42:
43: BEGIN
44: IF l_enable_log = 'Y' THEN
45: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Add_Default_Profile');

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

258: l_return_status VARCHAR2(1);
259: l_prev_profile_id NUMBER := NULL;
260: l_msg_index_out NUMBER := 0;
261: l_end_date DATE := NULL;
262: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
263:
264: BEGIN
265: IF l_enable_log = 'Y' THEN
266: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Update_Default_Profile');

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

455: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
456: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
457: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
458:
459: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
460:
461: BEGIN
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: x_msg_count := 0;

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

499: l_profile_start_date DATE;
500: l_profile_end_date DATE;
501: l_end_date DATE := p_resource_end_date;
502: l_return_status VARCHAR2(1);
503: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
504:
505: TYPE number_tbl IS TABLE OF NUMBER
506: INDEX BY BINARY_INTEGER;
507: