APPS.PA_COMP_PROFILE_PVT dependencies on FND_PROFILE

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

52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added the nocopy hint
55:
56: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
57: l_data VARCHAR2(500);
58: l_msg_data VARCHAR2(500);
59: l_msg_index_out NUMBER := 0;
60: l_project_id NUMBER := 0;

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

186: l_return_status VARCHAR2(30);
187: l_object_version_number NUMBER ;
188: l_error_message_code VARCHAR2(30);
189: l_approval_required BOOLEAN := TRUE;
190: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
191:
192: BEGIN
193: -- dbms_output.put_line('Entering Update_competence_element');
194: -- dbms_output.put_line('Effective Date From ' || p_effective_date_from);

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

334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint
335: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint
336: x_error_message_code OUT NOCOPY VARCHAR2) IS -- 4537865 Added the nocopy hint
337:
338: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
339:
340: CURSOR l_check_element_csr IS
341: SELECT object_name,
342: object_id,

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

381: END Check_Element_id ;
382:
383: PROCEDURE Check_Error (p_return_status IN VARCHAR2,
384: p_error_message_code IN VARCHAR2) IS
385: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
386: BEGIN
387: IF l_enable_log = 'Y' THEN
388: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_error');
389: END IF;

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

405: p_object_version_number IN NUMBER,
406: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint
407: x_error_message_code OUT NOCOPY VARCHAR2) IS -- 4537865 Added the nocopy hint
408:
409: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
410:
411: CURSOR l_get_obj_vers_csr IS
412: SELECT object_version_number
413: FROM per_competence_elements

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

834: x_msg_count OUT NOCOPY NUMBER, -- 4537865 Added the nocopy hint
835: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865 Added the nocopy hint
836: IS
837: l_file_val VARCHAR2(100);
838: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
839:
840: cursor insert_profile IS
841: SELECT PERSON_ID,
842: OBJECT_VERSION_NUMBER,

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

1032: p_competence_id IN NUMBER,
1033: x_return_status OUT NOCOPY VARCHAR2, -- Added the nocopy hint for 4537865
1034: x_error_message_code OUT NOCOPY VARCHAR2) IS -- Added the nocopy hint for 4537865
1035: l_comp_bg_id NUMBER := null;
1036: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1037: BEGIN
1038: BEGIN
1039: SELECT business_group_id
1040: INTO l_comp_bg_id