APPS.AMW_LOAD_KEY_ACC_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 157: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

153: l_prb_counts number;
154:
155: l_has_proc_acct_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
156: BEGIN
157: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
158: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
159:
160: --
161: -- check access privilege

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

154:
155: l_has_proc_acct_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
156: BEGIN
157: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
158: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
159:
160: --
161: -- check access privilege
162: --

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

289: l_has_proc_acct_assoc_access := check_function(
290: p_function => 'AMW_UPD_RL_PROC_ACCT_ASSOC'
291: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
292: ,p_instance_pk1_value => l_PROCESS_ID
293: ,p_user_id => fnd_global.user_id);
294:
295: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%% l_has_proc_acct_assoc_access: '||l_has_proc_acct_assoc_access||' %%%%%%%%%%%%%%%');
296:
297: if(l_has_proc_acct_assoc_access = 'T')then