eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_LOAD_RCM_ORG_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 57: WHERE r.responsibility_id = fnd_global.resp_id

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

Line 58: AND r.application_id=fnd_global.resp_appl_id

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

Line 66: WHERE rf.application_id = fnd_global.resp_appl_id

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

Line 67: AND rf.responsibility_id = fnd_global.resp_id

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

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

403: ---03.04.2005 npanandi: added below var for data security checks
404: ---of Organization - Process to Risk association
405: l_has_proc_risk_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
406: BEGIN
407: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
408: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
409: fnd_file.put_line (fnd_file.LOG, 'batch id: '||p_batch_id);
410: fnd_file.put_line (fnd_file.LOG, 'user id: '||p_user_id);
411:

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

404: ---of Organization - Process to Risk association
405: l_has_proc_risk_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
406: BEGIN
407: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
408: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
409: fnd_file.put_line (fnd_file.LOG, 'batch id: '||p_batch_id);
410: fnd_file.put_line (fnd_file.LOG, 'user id: '||p_user_id);
411:
412: --

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

531: l_has_risk_access := check_function(
532: p_function => 'AMW_RISK_UPDATE_PRVLG'
533: ,p_object_name => 'AMW_RISK'
534: ,p_instance_pk1_value => lx_risk_id
535: ,p_user_id => fnd_global.user_id);
536: fnd_file.put_line (fnd_file.LOG, 'l_has_risk_access: '||l_has_risk_access);
537: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for rc_rec.risk_name: '||rc_rec.risk_name);
538:
539: IF l_has_risk_access <> 'T' then

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

634: p_role_name => 'AMW_RISK_OWNER_ROLE'
635: ,p_object_name => 'AMW_RISK'
636: ,p_grantee_type => 'P'
637: ,p_instance_pk1_value => lx_risk_id
638: ,p_user_id => FND_GLOBAL.USER_ID);
639: end if;
640: ---02.28.2005 npanandi: if new Control, grant CtrlOwner prvlg
641:
642: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);

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

828: l_has_ctrl_access := check_function(
829: p_function => 'AMW_CTRL_UPDATE_PRVLG'
830: ,p_object_name => 'AMW_CONTROL'
831: ,p_instance_pk1_value => lx_control_id
832: ,p_user_id => fnd_global.user_id);
833: fnd_file.put_line (fnd_file.LOG, 'l_has_ctrl_access: '||l_has_ctrl_access);
834: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for rc_rec.control_name: '||rc_rec.control_name);
835:
836: IF l_has_ctrl_access <> 'T' then

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

899: p_role_name => 'AMW_CTRL_OWNER_ROLE'
900: ,p_object_name => 'AMW_CONTROL'
901: ,p_grantee_type => 'P'
902: ,p_instance_pk1_value => lx_control_id
903: ,p_user_id => FND_GLOBAL.USER_ID);
904: end if;
905: ---03.03.2005 npanandi: if new Control, grant CtrlOwner prvlg
906:
907: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);

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

1046: ,p_object_name => 'AMW_PROCESS_ORGANIZATION'
1047: ---03.04.2005 npanandi: added pk1/pk2 for OrgId, ProcessId respectively
1048: ,p_instance_pk1_value => l_organization_ID
1049: ,p_instance_pk2_value => l_PROCESS_ID
1050: ,p_user_id => fnd_global.user_id);
1051: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%%%%% l_has_assn_access: '||l_has_assn_access||' %%%%%%%%%%%%%%%%%%');
1052:
1053: IF l_has_assn_access <> 'T' then
1054: v_err_msg := 'Cannot associate to this Process';

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

1615: p_function => 'AMW_UPD_ORG_PROC_RISK_ASSOC'
1616: ,p_object_name => 'AMW_PROCESS_ORGANIZATION'
1617: ,p_instance_pk1_value => l_organization_ID
1618: ,p_instance_pk2_value => l_PROCESS_ID
1619: ,p_user_id => fnd_global.user_id);
1620: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%%%%% l_has_proc_risk_access: '||l_has_proc_risk_access||' %%%%%%%%%%%%%%%%%%');
1621:
1622: IF l_has_proc_risk_access <> 'T' then
1623: v_err_msg := 'Cannot associate to this Process';

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

2756: l_has_assn_access := check_function(
2757: p_function => 'AMW_UPDATE_AP_DETAILS'
2758: ,p_object_name => 'AMW_AUDIT_PROCEDURE'
2759: ,p_instance_pk1_value => P_AUDIT_PROCEDURE_ID
2760: ,p_user_id => fnd_global.user_id);
2761: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%%%%% l_has_assn_access: '||l_has_assn_access||' %%%%%%%%%%%%%%%%%%');
2762:
2763: ---03.03.2005 npanandi: do the association, only if l_has_assn_access = 'T'
2764: if(l_has_assn_access = 'T') then