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.GMD_API_GRP dependencies on FND_GLOBAL

Line 590: l_user_id NUMBER := fnd_global.user_id;

586: FUNCTION Check_orgn_access(Entity VARCHAR2
587: ,Entity_id NUMBER)
588: RETURN BOOLEAN IS
589: l_owner_orgn_code VARCHAR2(4);
590: l_user_id NUMBER := fnd_global.user_id;
591: l_orgn_id NUMBER;
592: l_resp_name VARCHAR2(240) := fnd_global.resp_name;
593: l_dummy NUMBER := 0;
594:

Line 592: l_resp_name VARCHAR2(240) := fnd_global.resp_name;

588: RETURN BOOLEAN IS
589: l_owner_orgn_code VARCHAR2(4);
590: l_user_id NUMBER := fnd_global.user_id;
591: l_orgn_id NUMBER;
592: l_resp_name VARCHAR2(240) := fnd_global.resp_name;
593: l_dummy NUMBER := 0;
594:
595: BEGIN
596: IF (Entity = 'FORMULA') THEN

Line 722: l_resp_name VARCHAR2(240) := fnd_global.resp_name;

718:
719: /* Local variables. */
720: /* ================ */
721: l_ret NUMBER;
722: l_resp_name VARCHAR2(240) := fnd_global.resp_name;
723: l_owner_org VARCHAR2(3);
724:
725: Update_not_allowed_exp EXCEPTION;
726: BEGIN

Line 1028: WHERE rg.user_id = fnd_global.user_id

1024: FROM gmd_security_profiles sp
1025: WHERE sp.access_type_ind = 'U'
1026: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1027: FROM FND_USER_RESP_GROUPS rg
1028: WHERE rg.user_id = fnd_global.user_id
1029: AND SYSDATE BETWEEN rg.start_date
1030: AND NVL(rg.end_date, SYSDATE)
1031: )
1032: OR ( sp.user_id = V_default_user_id

Line 1033: OR sp.user_id = fnd_global.user_id

1029: AND SYSDATE BETWEEN rg.start_date
1030: AND NVL(rg.end_date, SYSDATE)
1031: )
1032: OR ( sp.user_id = V_default_user_id
1033: OR sp.user_id = fnd_global.user_id
1034: )
1035: )
1036: AND organization_id = P_owner_organization_id
1037: AND (other_organization_id IS NULL

Line 1042: AND a3.resp_application_id = fnd_global.resp_appl_id

1038: OR EXISTS ( SELECT NULL
1039: FROM org_access a3
1040: WHERE a3.organization_id = sp.other_organization_id
1041: AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE
1042: AND a3.resp_application_id = fnd_global.resp_appl_id
1043: AND a3.responsibility_id = fnd_global.resp_id
1044: )
1045: OR NOT EXISTS ( SELECT NULL
1046: FROM org_access a4

Line 1043: AND a3.responsibility_id = fnd_global.resp_id

1039: FROM org_access a3
1040: WHERE a3.organization_id = sp.other_organization_id
1041: AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE
1042: AND a3.resp_application_id = fnd_global.resp_appl_id
1043: AND a3.responsibility_id = fnd_global.resp_id
1044: )
1045: OR NOT EXISTS ( SELECT NULL
1046: FROM org_access a4
1047: WHERE a4.organization_id = sp.other_organization_id

Line 1059: OR sp.user_id = fnd_global.user_id

1055: SELECT sp.access_type_ind
1056: FROM gmd_security_profiles sp
1057: WHERE sp.assign_method_ind = 'A'
1058: AND ( ( sp.user_id = V_default_user_id
1059: OR sp.user_id = fnd_global.user_id
1060: )
1061: OR ( EXISTS ( SELECT rg.responsibility_id
1062: FROM FND_USER_RESP_GROUPS rg
1063: WHERE rg.user_id = fnd_global.user_id

Line 1063: WHERE rg.user_id = fnd_global.user_id

1059: OR sp.user_id = fnd_global.user_id
1060: )
1061: OR ( EXISTS ( SELECT rg.responsibility_id
1062: FROM FND_USER_RESP_GROUPS rg
1063: WHERE rg.user_id = fnd_global.user_id
1064: AND sp.responsibility_id = rg.responsibility_id
1065: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)
1066: )
1067: )

Line 1077: AND a1.resp_application_id = fnd_global.resp_appl_id

1073: )
1074: OR sp.other_organization_id = a1.organization_id
1075: )
1076: AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE
1077: AND a1.resp_application_id = fnd_global.resp_appl_id
1078: AND a1.responsibility_id = fnd_global.resp_id
1079: )
1080: OR
1081: NOT EXISTS ( SELECT NULL

Line 1078: AND a1.responsibility_id = fnd_global.resp_id

1074: OR sp.other_organization_id = a1.organization_id
1075: )
1076: AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE
1077: AND a1.resp_application_id = fnd_global.resp_appl_id
1078: AND a1.responsibility_id = fnd_global.resp_id
1079: )
1080: OR
1081: NOT EXISTS ( SELECT NULL
1082: FROM org_access a2

Line 1096: OR fs.user_id = fnd_global.user_id

1092: UNION
1093: SELECT fs.access_type_ind
1094: FROM gmd_formula_security fs
1095: WHERE ( ( fs.user_id = V_default_user_id
1096: OR fs.user_id = fnd_global.user_id
1097: )
1098: OR ( EXISTS ( SELECT rg.responsibility_id
1099: FROM FND_USER_RESP_GROUPS rg
1100: WHERE rg.user_id = fnd_global.user_id

Line 1100: WHERE rg.user_id = fnd_global.user_id

1096: OR fs.user_id = fnd_global.user_id
1097: )
1098: OR ( EXISTS ( SELECT rg.responsibility_id
1099: FROM FND_USER_RESP_GROUPS rg
1100: WHERE rg.user_id = fnd_global.user_id
1101: AND fs.responsibility_id = rg.responsibility_id
1102: AND SYSDATE BETWEEN rg.start_date
1103: AND NVL(rg.end_date, SYSDATE)
1104: )

Line 1115: AND ou.resp_application_id = fnd_global.resp_appl_id

1111: )
1112: OR fs.other_organization_id = ou.organization_id
1113: )
1114: AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE
1115: AND ou.resp_application_id = fnd_global.resp_appl_id
1116: AND ou.responsibility_id = fnd_global.resp_id
1117: )
1118: OR
1119: NOT EXISTS ( SELECT NULL

Line 1116: AND ou.responsibility_id = fnd_global.resp_id

1112: OR fs.other_organization_id = ou.organization_id
1113: )
1114: AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE
1115: AND ou.resp_application_id = fnd_global.resp_appl_id
1116: AND ou.responsibility_id = fnd_global.resp_id
1117: )
1118: OR
1119: NOT EXISTS ( SELECT NULL
1120: FROM org_access ou1