DBA Data[Home] [Help]

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

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

Line 60: AND r.application_id=fnd_global.resp_appl_id

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

Line 68: WHERE rf.application_id = fnd_global.resp_appl_id

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

Line 69: AND rf.responsibility_id = fnd_global.resp_id

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

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

404: l_has_risk_ctrl_assn_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
405: l_has_proc_obj_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
406: l_has_proc_risk_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
407: BEGIN
408: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
409: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
410:
411: --
412: -- check access privilege

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

405: l_has_proc_obj_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
406: l_has_proc_risk_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
407: BEGIN
408: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
409: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
410:
411: --
412: -- check access privilege
413: --

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

523: l_has_risk_access := check_function(
524: p_function => 'AMW_RISK_UPDATE_PRVLG'
525: ,p_object_name => 'AMW_RISK'
526: ,p_instance_pk1_value => lx_risk_id
527: ,p_user_id => fnd_global.user_id);
528: fnd_file.put_line (fnd_file.LOG, 'l_has_risk_access: '||l_has_risk_access);
529: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for rc_rec.risk_name: '||rc_rec.risk_name);
530:
531: IF l_has_risk_access <> 'T' then

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

612: p_role_name => 'AMW_RISK_OWNER_ROLE'
613: ,p_object_name => 'AMW_RISK'
614: ,p_grantee_type => 'P'
615: ,p_instance_pk1_value => lx_risk_id
616: ,p_user_id => FND_GLOBAL.USER_ID);
617: end if;
618: ---02.28.2005 npanandi: if new Control, grant CtrlOwner prvlg
619:
620: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);

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

811: l_has_ctrl_access := check_function(
812: p_function => 'AMW_CTRL_UPDATE_PRVLG'
813: ,p_object_name => 'AMW_CONTROL'
814: ,p_instance_pk1_value => lx_control_id
815: ,p_user_id => fnd_global.user_id);
816: fnd_file.put_line (fnd_file.LOG, 'l_has_ctrl_access: '||l_has_ctrl_access);
817: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for rc_rec.control_name: '||rc_rec.control_name);
818:
819: IF l_has_ctrl_access <> 'T' then

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

883: p_role_name => 'AMW_CTRL_OWNER_ROLE'
884: ,p_object_name => 'AMW_CONTROL'
885: ,p_grantee_type => 'P'
886: ,p_instance_pk1_value => lx_control_id
887: ,p_user_id => FND_GLOBAL.USER_ID);
888: end if;
889: ---03.01.2005 npanandi: if new Control, grant CtrlOwner prvlg
890:
891: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);

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

1042: l_has_risk_ctrl_assn_access := check_function(
1043: p_function => 'AMW_UPD_RL_PROC_RISK_CTRL_ASSN'
1044: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1045: ,p_instance_pk1_value => l_PROCESS_ID
1046: ,p_user_id => fnd_global.user_id);
1047: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%%%%% l_has_risk_ctrl_assn_access: '||l_has_risk_ctrl_assn_access||' %%%%%%%%%%%%%%%%%%');
1048:
1049: IF(L_CONTROL_ASSOCIATION_ID IS NULL and l_has_risk_ctrl_assn_access = 'T') THEN
1050: --NO ROW RETRIEVED, SO ASSOCIATION DOESN'T EXIST YET

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

1135: l_has_ap_access := check_function(
1136: p_function => 'AMW_UPDATE_AP_DETAILS'
1137: ,p_object_name => 'AMW_AUDIT_PROCEDURE'
1138: ,p_instance_pk1_value => RC_REC.AP_NAME
1139: ,p_user_id => fnd_global.user_id);
1140: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%%%%% l_has_ap_access: '||l_has_ap_access||' %%%%%%%%%%%%%%%%%%');
1141:
1142: IF(L_ASSOC_AP_TO_CTRL and l_has_ap_access = 'T') THEN --putting this check, because Ctrl
1143: --to AP association is only for Approved Ctrls

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

1337: l_has_proc_obj_assoc_access := check_function(
1338: p_function => 'AMW_UPD_RL_PROC_OBJ_ASSOC'
1339: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1340: ,p_instance_pk1_value => l_process_id
1341: ,p_user_id => fnd_global.user_id);
1342: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%%%%%% l_has_proc_obj_assoc_access: '||l_has_proc_obj_assoc_access||' %%%%%%%%%%%%%%%%%%%');
1343:
1344: fnd_file.put_line (fnd_file.LOG, 'inside if for process: l_process_objective_id '||l_process_objective_id);
1345: fnd_file.put_line (fnd_file.LOG, 'inside if for risk: l_process_objectives_count '||l_process_objectives_count);

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

1600: l_has_proc_risk_assoc_access := check_function(
1601: p_function => 'AMW_UPD_RL_PROC_RISK_ASSOC'
1602: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
1603: ,p_instance_pk1_value => L_PROCESS_ID
1604: ,p_user_id => fnd_global.user_id);
1605: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%% l_has_proc_risk_assoc_access: '||l_has_proc_risk_assoc_access||' %%%%%%%%%%%%%%%');
1606:
1607: ---03.02.2005 npanandi: added this for access privilege
1608: ---check before inserting/update AmwRiskAssociations

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

2589: l_has_risk_ctrl_assn_access := check_function(
2590: p_function => 'AMW_UPD_RL_PROC_RISK_CTRL_ASSN'
2591: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
2592: ,p_instance_pk1_value => P_PROCESS_ID
2593: ,p_user_id => fnd_global.user_id);
2594:
2595: fnd_file.put_line(fnd_file.log,'&&&&&&&&&&&&&&& l_has_risk_ctrl_assn_access: '||l_has_risk_ctrl_assn_access||' &&&&&&&&&&&&&&&');
2596: --03.02.2005 npanandi: imposing the foll. IF condition to
2597: --create the association only if access privilege is present

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

2649: l_has_ap_access := check_function(
2650: p_function => 'AMW_UPDATE_AP_DETAILS'
2651: ,p_object_name => 'AMW_AUDIT_PROCEDURE'
2652: ,p_instance_pk1_value => P_AUDIT_PROCEDURE_ID
2653: ,p_user_id => fnd_global.user_id);
2654:
2655: fnd_file.put_line(fnd_file.log,'&&&&&&&&&&&&&&& l_has_ap_access: '||l_has_ap_access||' &&&&&&&&&&&&&&&');
2656: --03.01.2005 npanandi: imposing the foll. IF condition to
2657: --create the association only if access privilege is present

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

2726: l_has_proc_obj_assoc_access := check_function(
2727: p_function => 'AMW_UPD_RL_PROC_OBJ_ASSOC'
2728: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
2729: ,p_instance_pk1_value => P_PK1
2730: ,p_user_id => fnd_global.user_id);
2731: end if;
2732:
2733: fnd_file.put_line(fnd_file.log,'&&&&&&&&&&&&&&& l_has_proc_obj_assoc_access: '||l_has_proc_obj_assoc_access||' &&&&&&&&&&&&&&&');
2734: --03.02.2005 npanandi: imposing the foll. IF condition to

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

2790: l_has_proc_risk_assoc_access := check_function(
2791: p_function => 'AMW_UPD_RL_PROC_RISK_ASSOC'
2792: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
2793: ,p_instance_pk1_value => P_PROCESS_ID
2794: ,p_user_id => fnd_global.user_id);
2795:
2796: fnd_file.put_line(fnd_file.log,'&&&&&&&&&&&&&&& l_has_proc_risk_assoc_access: '||l_has_proc_risk_assoc_access||' &&&&&&&&&&&&&&&');
2797: --03.02.2005 npanandi: imposing the foll. IF condition to
2798: --create the association only if access privilege is present