APPS.AMW_LOAD_CTRL_DATA dependencies on FND_GLOBAL

Line 24: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

20: --
21: -- Used for exception processing
22: --
23:
24: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
25: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
26: v_error_found BOOLEAN DEFAULT FALSE;
27: v_user_id NUMBER;
28: v_interface_id NUMBER;

Line 25: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

21: -- Used for exception processing
22: --
23:
24: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
25: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
26: v_error_found BOOLEAN DEFAULT FALSE;
27: v_user_id NUMBER;
28: v_interface_id NUMBER;
29: vx_control_rev_id NUMBER;

Line 50: WHERE r.responsibility_id = fnd_global.resp_id

46: IS
47: CURSOR c_func_exists IS
48: SELECT 'Y'
49: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
50: WHERE r.responsibility_id = fnd_global.resp_id
51: AND r.application_id=fnd_global.resp_appl_id
52: AND r.menu_id = m.menu_id
53: AND m.function_id = f.function_id
54: AND f.function_name = v_import_func;

Line 51: AND r.application_id=fnd_global.resp_appl_id

47: CURSOR c_func_exists IS
48: SELECT 'Y'
49: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
50: WHERE r.responsibility_id = fnd_global.resp_id
51: AND r.application_id=fnd_global.resp_appl_id
52: AND r.menu_id = m.menu_id
53: AND m.function_id = f.function_id
54: AND f.function_name = v_import_func;
55: CURSOR c_func_excluded IS

Line 58: WHERE rf.application_id = fnd_global.resp_appl_id

54: AND f.function_name = v_import_func;
55: CURSOR c_func_excluded IS
56: SELECT 'Y'
57: FROM fnd_resp_functions rf, fnd_form_functions f
58: WHERE rf.application_id = fnd_global.resp_appl_id
59: AND rf.responsibility_id = fnd_global.resp_id
60: AND rf.rule_type = 'F'
61: AND rf.action_id = f.function_id
62: AND f.function_name = v_import_func;

Line 59: AND rf.responsibility_id = fnd_global.resp_id

55: CURSOR c_func_excluded IS
56: SELECT 'Y'
57: FROM fnd_resp_functions rf, fnd_form_functions f
58: WHERE rf.application_id = fnd_global.resp_appl_id
59: AND rf.responsibility_id = fnd_global.resp_id
60: AND rf.rule_type = 'F'
61: AND rf.action_id = f.function_id
62: AND f.function_name = v_import_func;
63:

Line 303: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

299: l_new_control boolean default true;
300: l_has_access varchar2(15);
301:
302: BEGIN
303: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
304: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
305:
306: --
307: -- check access privilege

Line 304: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);

300: l_has_access varchar2(15);
301:
302: BEGIN
303: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
304: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
305:
306: --
307: -- check access privilege
308: --

Line 386: ,p_user_id => fnd_global.user_id);

382: l_has_access := check_function(
383: p_function => 'AMW_CTRL_UPDATE_PRVLG'
384: ,p_object_name => 'AMW_CONTROL'
385: ,p_instance_pk1_value => lx_control_id
386: ,p_user_id => fnd_global.user_id);
387: fnd_file.put_line (fnd_file.LOG, 'l_has_access: '||l_has_access);
388: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for l_control_name: '||l_control_name);
389:
390: IF l_has_access <> 'T' then

Line 473: ,p_user_id => FND_GLOBAL.USER_ID);

469: p_role_name => 'AMW_CTRL_OWNER_ROLE'
470: ,p_object_name => 'AMW_CONTROL'
471: ,p_grantee_type => 'P'
472: ,p_instance_pk1_value => lx_control_id
473: ,p_user_id => FND_GLOBAL.USER_ID);
474: end if;
475: ---02.28.2005 npanandi: if new Control, grant CtrlOwner prvlg
476:
477: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);