DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on ORG_ACCESS

Line 604: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN

600: WHERE a.formula_id = Entity_id
601: AND a.owner_organization_id = b.organization_id;
602:
603: /* Check if user has access to this formula orgn */
604: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN
605: FND_MESSAGE.SET_NAME('GMD','GMD_FORMULA_NOT_UPDATEABLE');
606: FND_MESSAGE.SET_TOKEN('RESP_NAME',l_resp_name);
607: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_Owner_orgn_code);
608: FND_MSG_PUB.ADD;

Line 620: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN

616: WHERE recipe_id = Entity_id
617: AND a.owner_organization_id = b.organization_id;
618:
619: /* Check if user has access to this Recipe orgn */
620: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN
621: FND_MESSAGE.SET_NAME('GMD','GMD_RECIPE_NOT_UPDATEABLE');
622: FND_MESSAGE.SET_TOKEN('RESP_NAME',l_resp_name);
623: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_Owner_orgn_code);
624: FND_MSG_PUB.ADD;

Line 639: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN

635:
636: -- Check if user has access to this Recipe orgn
637: IF (l_owner_orgn_code IS NOT NULL) THEN
638: /* Check if user resp has access to this VR orgn */
639: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN
640: FND_MESSAGE.SET_NAME('GMD','GMD_RECIPE_NOT_UPDATEABLE');
641: FND_MESSAGE.SET_TOKEN('RESP_NAME',l_resp_name);
642: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_Owner_orgn_code);
643: FND_MSG_PUB.ADD;

Line 658: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN

654: WHERE a.routing_id = Entity_id
655: AND a.owner_organization_id = b.organization_id;
656:
657: /* Check if user has access to this formula orgn */
658: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN
659: FND_MESSAGE.SET_NAME('GMD','GMD_ROUTING_NOT_UPDATEABLE');
660: FND_MESSAGE.SET_TOKEN('RESP_NAME',l_resp_name);
661: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_Owner_orgn_code);
662: FND_MSG_PUB.ADD;

Line 673: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN

669: WHERE a.oprn_id = Entity_id
670: AND a.owner_organization_id = b.organization_id;
671:
672: /* Check if user has access to this formula orgn */
673: IF NOT (gmd_api_grp.OrgnAccessible(l_orgn_id)) THEN
674: FND_MESSAGE.SET_NAME('GMD','GMD_OPERATION_NOT_UPDATEABLE');
675: FND_MESSAGE.SET_TOKEN('RESP_NAME',l_resp_name);
676: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_Owner_orgn_code);
677: FND_MSG_PUB.ADD;

Line 694: * OrgnAccessible() *

690:
691:
692: /* *********************************************************************** *
693: * Function *
694: * OrgnAccessible() *
695: * Parameter : powner_orgn_id IN NUMBER
696: * Description *
697: * Checks if the user has access to the entity organization *
698: * during the creation of a new instance *

Line 701: FUNCTION OrgnAccessible(powner_orgn_id IN NUMBER) RETURN BOOLEAN IS

697: * Checks if the user has access to the entity organization *
698: * during the creation of a new instance *
699: * *********************************************************************** */
700:
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;

Line 711: from org_access_view a, mtl_parameters b

707: CURSOR Cur_ownerorgn_id IS
708: SELECT 1
709: FROM SYS.DUAL
710: WHERE EXISTS (SELECT 1
711: from org_access_view a, mtl_parameters b
712: where a.organization_id = b.organization_id
713: and b.organization_id = powner_orgn_id
714: and a.responsibility_id = l_responsibility_id --Bug 14000659
715: and b.process_enabled_flag = 'Y');

Line 757: END OrgnAccessible;

753: WHEN OTHERS THEN
754: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_USER_ORGANIZATION');
755: FND_MSG_PUB.ADD;
756: RETURN FALSE;
757: END OrgnAccessible;
758:
759: /* *********************************************************************** *
760: * Function *
761: * get_object_status_type *

Line 1043: FROM org_access a3

1039: )
1040: AND organization_id = P_owner_organization_id
1041: AND (other_organization_id IS NULL
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

Line 1050: FROM org_access a4

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
1052: AND NVL(a4.disable_date, SYSDATE+1) >=SYSDATE
1053: )
1054: )

Line 1075: FROM org_access a1

1071: )
1072: )
1073: )
1074: AND ( EXISTS ( SELECT NULL
1075: FROM org_access a1
1076: WHERE ( ( sp.organization_id = a1.organization_id
1077: AND sp.other_organization_id IS NULL
1078: )
1079: OR sp.other_organization_id = a1.organization_id

Line 1087: FROM org_access a2

1083: AND a1.responsibility_id = fnd_global.resp_id
1084: )
1085: OR
1086: NOT EXISTS ( SELECT NULL
1087: FROM org_access a2
1088: WHERE ( ( sp.organization_id = a2.organization_id
1089: AND sp.other_organization_id IS NULL
1090: )
1091: OR sp.other_organization_id = a2.organization_id

Line 1114: FROM org_access ou

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
1117: )
1118: OR fs.other_organization_id = ou.organization_id

Line 1126: FROM org_access ou1

1122: AND ou.responsibility_id = fnd_global.resp_id
1123: )
1124: OR
1125: NOT EXISTS ( SELECT NULL
1126: FROM org_access ou1
1127: WHERE ( ( ou1.organization_id = fs.organization_id
1128: AND fs.other_organization_id IS NULL
1129: )
1130: OR ou1.organization_id = fs.other_organization_id