APPS.PA_SECURITY_PVT dependencies on FND_PROFILE

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

5: G_user_id NUMBER:=FND_GLOBAL.USER_ID;
6: G_source_type VARCHAR2(30) := '';
7: G_source_id NUMBER;
8: G_grantee_key VARCHAR2(240) := '';
9: G_debug_flag varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
10: G_source_type_id NUMBER;
11: G_project_system_status_code VARCHAR2(30) := '';
12: G_project_roles_ins_set_id NUMBER;
13: G_project_roles_ins_set_name FND_OBJECT_INSTANCE_SETS.instance_set_name%TYPE := 'PA_PROJECT_ROLES';

Line 26: G_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

22: l_cust_id NUMBER;
23: BEGIN
24: G_responsibility_id := FND_GLOBAL.RESP_ID;
25: G_user_id := FND_GLOBAL.USER_ID;
26: G_debug_flag := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
27: G_project_roles_ins_set_id := get_instance_set_id(G_project_roles_ins_set_name);
28:
29: SELECT employee_id, person_party_id -- Bug 4527617. Replaced customer_id with person_party_id.
30: INTO l_emp_id, l_cust_id

Line 701: v_resource_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',

697: IF G_debug_flag = 'Y' THEN
698: pa_debug.write_file( 'LOG', pa_debug.G_err_stage);
699: END IF;
700:
701: v_resource_super_user := fnd_profile.value_specific('PA_SUPER_RESOURCE',
702: G_USER_ID,
703: G_RESPONSIBILITY_ID ,
704: fnd_global.resp_appl_id);
705: IF v_resource_super_user = 'Y' THEN