APPS.PA_PROJECT_SET_UTILS dependencies on FND_PROFILE

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

14: )
15: IS
16: l_employee_id fnd_user.employee_id%type;
17: l_customer_id fnd_user.person_party_id%type; -- 4586987 changed from customer_id to person_party_id
18: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
19: BEGIN
20: -- 4586987 changed customer_id to person_party_id
21: /*
22: SELECT employee_id, customer_id

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

256: l_proj_set_name pa_project_sets_tl.name%TYPE;
257: l_project_list VARCHAR2(2000) := '';
258: l_project_name pa_projects_all.name%TYPE;
259: l_project_number pa_projects_all.segment1%TYPE;
260: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
261:
262: CURSOR get_proj_name_number(l_project_id IN NUMBER)
263: IS
264: SELECT name, segment1

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

335: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
336: x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
337: IS
338:
339: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
340:
341: BEGIN
342:
343: -- Initialize the Error Stack

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

392: IS
393: l_current_id NUMBER := NULL;
394: l_num_ids NUMBER := 0;
395: l_id_found_flag VARCHAR(1) := 'N';
396: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
397:
398: CURSOR p_ids IS
399: SELECT project_set_id
400: FROM pa_project_sets_vl