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: CURSOR Cur_ownerorgn_id IS
705: SELECT 1

Line 708: from org_access_view a, mtl_parameters b

704: CURSOR Cur_ownerorgn_id IS
705: SELECT 1
706: FROM SYS.DUAL
707: WHERE EXISTS (SELECT 1
708: from org_access_view a, mtl_parameters b
709: where a.organization_id = b.organization_id
710: and b.organization_id = powner_orgn_id
711: and a.responsibility_id = l_resp_id
712: and b.process_enabled_flag = 'Y');

Line 754: END OrgnAccessible;

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

Line 1039: FROM org_access a3

1035: )
1036: AND organization_id = P_owner_organization_id
1037: AND (other_organization_id IS NULL
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

Line 1046: FROM org_access a4

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
1048: AND NVL(a4.disable_date, SYSDATE+1) >=SYSDATE
1049: )
1050: )

Line 1070: FROM org_access a1

1066: )
1067: )
1068: )
1069: AND ( EXISTS ( SELECT NULL
1070: FROM org_access a1
1071: WHERE ( ( sp.organization_id = a1.organization_id
1072: AND sp.other_organization_id IS NULL
1073: )
1074: OR sp.other_organization_id = a1.organization_id

Line 1082: FROM org_access a2

1078: AND a1.responsibility_id = fnd_global.resp_id
1079: )
1080: OR
1081: NOT EXISTS ( SELECT NULL
1082: FROM org_access a2
1083: WHERE ( ( sp.organization_id = a2.organization_id
1084: AND sp.other_organization_id IS NULL
1085: )
1086: OR sp.other_organization_id = a2.organization_id

Line 1108: FROM org_access ou

1104: )
1105: )
1106: )
1107: AND (EXISTS ( SELECT NULL
1108: FROM org_access ou
1109: WHERE ( ( fs.organization_id = ou.organization_id
1110: AND fs.other_organization_id IS NULL
1111: )
1112: OR fs.other_organization_id = ou.organization_id

Line 1120: FROM org_access ou1

1116: AND ou.responsibility_id = fnd_global.resp_id
1117: )
1118: OR
1119: NOT EXISTS ( SELECT NULL
1120: FROM org_access ou1
1121: WHERE ( ( ou1.organization_id = fs.organization_id
1122: AND fs.other_organization_id IS NULL
1123: )
1124: OR ou1.organization_id = fs.other_organization_id