DBA Data[Home] [Help]

APPS.AMW_LOAD_AP_DATA dependencies on FND_GLOBAL

Line 28: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

24:
25: type t_AP_name IS table of amw_AP_INTERFACE.AP_name%type INDEX BY BINARY_INTEGER;
26: v_AP_name t_AP_name;
27:
28: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
29: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
30: v_error_found BOOLEAN DEFAULT FALSE;
31: v_user_id NUMBER;
32: v_interface_id NUMBER;

Line 29: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

25: type t_AP_name IS table of amw_AP_INTERFACE.AP_name%type INDEX BY BINARY_INTEGER;
26: v_AP_name t_AP_name;
27:
28: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
29: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
30: v_error_found BOOLEAN DEFAULT FALSE;
31: v_user_id NUMBER;
32: v_interface_id NUMBER;
33: vx_control_rev_id NUMBER;

Line 61: WHERE r.responsibility_id = fnd_global.resp_id

57: IS
58: CURSOR c_func_exists IS
59: SELECT 'Y'
60: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
61: WHERE r.responsibility_id = fnd_global.resp_id
62: AND r.application_id=fnd_global.resp_appl_id
63: AND r.menu_id = m.menu_id
64: AND m.function_id = f.function_id
65: AND f.function_name = v_import_func;

Line 62: AND r.application_id=fnd_global.resp_appl_id

58: CURSOR c_func_exists IS
59: SELECT 'Y'
60: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
61: WHERE r.responsibility_id = fnd_global.resp_id
62: AND r.application_id=fnd_global.resp_appl_id
63: AND r.menu_id = m.menu_id
64: AND m.function_id = f.function_id
65: AND f.function_name = v_import_func;
66: CURSOR c_func_excluded IS

Line 69: WHERE rf.application_id = fnd_global.resp_appl_id

65: AND f.function_name = v_import_func;
66: CURSOR c_func_excluded IS
67: SELECT 'Y'
68: FROM fnd_resp_functions rf, fnd_form_functions f
69: WHERE rf.application_id = fnd_global.resp_appl_id
70: AND rf.responsibility_id = fnd_global.resp_id
71: AND rf.rule_type = 'F'
72: AND rf.action_id = f.function_id
73: AND f.function_name = v_import_func;

Line 70: AND rf.responsibility_id = fnd_global.resp_id

66: CURSOR c_func_excluded IS
67: SELECT 'Y'
68: FROM fnd_resp_functions rf, fnd_form_functions f
69: WHERE rf.application_id = fnd_global.resp_appl_id
70: AND rf.responsibility_id = fnd_global.resp_id
71: AND rf.rule_type = 'F'
72: AND rf.action_id = f.function_id
73: AND f.function_name = v_import_func;
74:

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

233: ---03.01.2005 npanandi:
234: l_new_ap boolean default true;
235: l_has_access varchar2(15);
236: BEGIN
237: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
238: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
239:
240: --
241: -- check access privilege

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

234: l_new_ap boolean default true;
235: l_has_access varchar2(15);
236: BEGIN
237: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
238: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
239:
240: --
241: -- check access privilege
242: --

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

367: l_has_access := check_function(
368: p_function => 'AMW_UPDATE_AP_DETAILS'
369: ,p_object_name => 'AMW_AUDIT_PROCEDURE'
370: ,p_instance_pk1_value => lx_audit_procedure_id
371: ,p_user_id => fnd_global.user_id);
372:
373: IF l_has_access <> 'T' then
374: v_err_msg := 'Cannot update this Audit Procedure';
375: update_interface_with_error (v_err_msg

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

400: p_role_name => 'AMW_AP_OWNER_ROLE'
401: ,p_object_name => 'AMW_AUDIT_PROCEDURE'
402: ,p_grantee_type => 'P'
403: ,p_instance_pk1_value => lx_audit_procedure_id
404: ,p_user_id => FND_GLOBAL.USER_ID);
405: end if;
406: ---03.01.2005 npanandi: if new Audit Procedure, grant APOwner prvlg
407:
408: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then