DBA Data[Home] [Help]

APPS.AMW_LOAD_PROC_DATA dependencies on FND_GLOBAL

Line 21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

17: --
18: -- Used FOR EXCEPTION processing
19: --
20:
21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
23: v_error_found BOOLEAN DEFAULT FALSE;
24: ----v_user_id NUMBER;
25: v_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

18: -- Used FOR EXCEPTION processing
19: --
20:
21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
23: v_error_found BOOLEAN DEFAULT FALSE;
24: ----v_user_id NUMBER;
25: v_user_id NUMBER := FND_GLOBAL.USER_ID;
26: v_interface_id NUMBER;

Line 25: v_user_id NUMBER := FND_GLOBAL.USER_ID;

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

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

278: ---05.11.2005 npanandi: added below variable for check before Approving
279: l_db_proc_appr_status varchar2(1);
280: l_db_process_display_name varchar2(80);
281: BEGIN
282: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
283: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
284: fnd_file.put_line (fnd_file.LOG, 'Batch_Id: '||p_batch_id);
285: -- Check that User has access to Process Import Functionality
286:

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

279: l_db_proc_appr_status varchar2(1);
280: l_db_process_display_name varchar2(80);
281: BEGIN
282: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
283: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
284: fnd_file.put_line (fnd_file.LOG, 'Batch_Id: '||p_batch_id);
285: -- Check that User has access to Process Import Functionality
286:
287: ---05.11.2005 npanandi: included the below statement to count

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

505: l_has_access := check_function(
506: p_function => 'AMW_UPD_RL_PROC'
507: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
508: ,p_instance_pk1_value => L_PROCESS_ID
509: ,p_user_id => fnd_global.user_id);
510:
511: IF l_has_access <> 'T' then
512: v_err_msg := 'Cannot update this Process';
513: update_interface_with_error (v_err_msg

Line 1249: WHERE r.responsibility_id = fnd_global.resp_id

1245:
1246: CURSOR c_func_exists IS
1247: SELECT 'Y'
1248: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_FORm_functions f
1249: WHERE r.responsibility_id = fnd_global.resp_id
1250: AND r.application_id=fnd_global.resp_appl_id
1251: AND r.menu_id = m.menu_id
1252: AND m.function_id = f.function_id
1253: AND f.function_name = p_function_name;

Line 1250: AND r.application_id=fnd_global.resp_appl_id

1246: CURSOR c_func_exists IS
1247: SELECT 'Y'
1248: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_FORm_functions f
1249: WHERE r.responsibility_id = fnd_global.resp_id
1250: AND r.application_id=fnd_global.resp_appl_id
1251: AND r.menu_id = m.menu_id
1252: AND m.function_id = f.function_id
1253: AND f.function_name = p_function_name;
1254:

Line 1258: WHERE rf.application_id = fnd_global.resp_appl_id

1254:
1255: CURSOR c_func_excluded IS
1256: SELECT 'Y'
1257: FROM fnd_resp_functions rf, fnd_FORm_functions f
1258: WHERE rf.application_id = fnd_global.resp_appl_id
1259: AND rf.responsibility_id = fnd_global.resp_id
1260: AND rf.rule_type = 'F'
1261: AND rf.action_id = f.function_id
1262: AND f.function_name = p_function_name;

Line 1259: AND rf.responsibility_id = fnd_global.resp_id

1255: CURSOR c_func_excluded IS
1256: SELECT 'Y'
1257: FROM fnd_resp_functions rf, fnd_FORm_functions f
1258: WHERE rf.application_id = fnd_global.resp_appl_id
1259: AND rf.responsibility_id = fnd_global.resp_id
1260: AND rf.rule_type = 'F'
1261: AND rf.action_id = f.function_id
1262: AND f.function_name = p_function_name;
1263:

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

1515: p_role_name => 'AMW_RL_PROC_OWNER_ROLE'
1516: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1517: ,p_grantee_type => 'P'
1518: ,p_instance_pk1_value => l_process_id
1519: ,p_user_id => FND_GLOBAL.USER_ID);
1520: **/
1521: ---04.22.2005 npanandi: commented out above grants for now
1522:
1523: ---04.22.2005 npanandi: added below grants bug 4323387