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 705: l_responsibility_id NUMBER := fnd_global.resp_id;

701: FUNCTION OrgnAccessible(powner_orgn_id IN NUMBER) RETURN BOOLEAN IS
702: /* Cursor Definitions. */
703: /* =================== */
704: --Added the following line to fix the bug 14000659.
705: l_responsibility_id NUMBER := fnd_global.resp_id;
706:
707: CURSOR Cur_ownerorgn_id IS
708: SELECT 1
709: FROM SYS.DUAL

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

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

Line 1029: AND nvl(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */

1025: FROM sys.dual
1026: WHERE EXISTS ( SELECT 1
1027: FROM gmd_security_profiles sp
1028: WHERE sp.access_type_ind = 'U'
1029: AND nvl(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1030: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1031: FROM FND_USER_RESP_GROUPS rg
1032: WHERE rg.user_id = fnd_global.user_id
1033: AND SYSDATE BETWEEN rg.start_date

Line 1032: WHERE rg.user_id = fnd_global.user_id

1028: WHERE sp.access_type_ind = 'U'
1029: AND nvl(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1030: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1031: FROM FND_USER_RESP_GROUPS rg
1032: WHERE rg.user_id = fnd_global.user_id
1033: AND SYSDATE BETWEEN rg.start_date
1034: AND NVL(rg.end_date, SYSDATE)
1035: )
1036: OR ( sp.user_id = V_default_user_id

Line 1037: OR sp.user_id = fnd_global.user_id

1033: AND SYSDATE BETWEEN rg.start_date
1034: AND NVL(rg.end_date, SYSDATE)
1035: )
1036: OR ( sp.user_id = V_default_user_id
1037: OR sp.user_id = fnd_global.user_id
1038: )
1039: )
1040: AND organization_id = P_owner_organization_id
1041: AND (other_organization_id IS NULL

Line 1046: AND a3.resp_application_id = fnd_global.resp_appl_id

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

Line 1047: AND a3.responsibility_id = fnd_global.resp_id

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

Line 1062: AND NVL(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */

1058: CURSOR Cur_check_formula_access (V_default_user_id PLS_INTEGER) IS
1059: SELECT sp.access_type_ind
1060: FROM gmd_security_profiles sp
1061: WHERE sp.assign_method_ind = 'A'
1062: AND NVL(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1063: AND ( ( sp.user_id = V_default_user_id
1064: OR sp.user_id = fnd_global.user_id
1065: )
1066: OR ( EXISTS ( SELECT rg.responsibility_id

Line 1064: OR sp.user_id = fnd_global.user_id

1060: FROM gmd_security_profiles sp
1061: WHERE sp.assign_method_ind = 'A'
1062: AND NVL(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1063: AND ( ( sp.user_id = V_default_user_id
1064: OR sp.user_id = fnd_global.user_id
1065: )
1066: OR ( EXISTS ( SELECT rg.responsibility_id
1067: FROM FND_USER_RESP_GROUPS rg
1068: WHERE rg.user_id = fnd_global.user_id

Line 1068: WHERE rg.user_id = fnd_global.user_id

1064: OR sp.user_id = fnd_global.user_id
1065: )
1066: OR ( EXISTS ( SELECT rg.responsibility_id
1067: FROM FND_USER_RESP_GROUPS rg
1068: WHERE rg.user_id = fnd_global.user_id
1069: AND sp.responsibility_id = rg.responsibility_id
1070: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)
1071: )
1072: )

Line 1082: AND a1.resp_application_id = fnd_global.resp_appl_id

1078: )
1079: OR sp.other_organization_id = a1.organization_id
1080: )
1081: AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE
1082: AND a1.resp_application_id = fnd_global.resp_appl_id
1083: AND a1.responsibility_id = fnd_global.resp_id
1084: )
1085: OR
1086: NOT EXISTS ( SELECT NULL

Line 1083: AND a1.responsibility_id = fnd_global.resp_id

1079: OR sp.other_organization_id = a1.organization_id
1080: )
1081: AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE
1082: AND a1.resp_application_id = fnd_global.resp_appl_id
1083: AND a1.responsibility_id = fnd_global.resp_id
1084: )
1085: OR
1086: NOT EXISTS ( SELECT NULL
1087: FROM org_access a2

Line 1101: OR fs.user_id = fnd_global.user_id

1097: UNION
1098: SELECT fs.access_type_ind
1099: FROM gmd_formula_security fs
1100: WHERE ( ( fs.user_id = V_default_user_id
1101: OR fs.user_id = fnd_global.user_id
1102: )
1103: OR ( EXISTS ( SELECT rg.responsibility_id
1104: FROM FND_USER_RESP_GROUPS rg
1105: WHERE rg.user_id = fnd_global.user_id

Line 1105: WHERE rg.user_id = fnd_global.user_id

1101: OR fs.user_id = fnd_global.user_id
1102: )
1103: OR ( EXISTS ( SELECT rg.responsibility_id
1104: FROM FND_USER_RESP_GROUPS rg
1105: WHERE rg.user_id = fnd_global.user_id
1106: AND fs.responsibility_id = rg.responsibility_id
1107: AND SYSDATE BETWEEN rg.start_date
1108: AND NVL(rg.end_date, SYSDATE)
1109: )

Line 1112: AND nvl(responsibility_id,fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */

1108: AND NVL(rg.end_date, SYSDATE)
1109: )
1110: )
1111: )
1112: AND nvl(responsibility_id,fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1113: AND (EXISTS ( SELECT NULL
1114: FROM org_access ou
1115: WHERE ( ( fs.organization_id = ou.organization_id
1116: AND fs.other_organization_id IS NULL

Line 1121: AND ou.resp_application_id = fnd_global.resp_appl_id

1117: )
1118: OR fs.other_organization_id = ou.organization_id
1119: )
1120: AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE
1121: AND ou.resp_application_id = fnd_global.resp_appl_id
1122: AND ou.responsibility_id = fnd_global.resp_id
1123: )
1124: OR
1125: NOT EXISTS ( SELECT NULL

Line 1122: AND ou.responsibility_id = fnd_global.resp_id

1118: OR fs.other_organization_id = ou.organization_id
1119: )
1120: AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE
1121: AND ou.resp_application_id = fnd_global.resp_appl_id
1122: AND ou.responsibility_id = fnd_global.resp_id
1123: )
1124: OR
1125: NOT EXISTS ( SELECT NULL
1126: FROM org_access ou1