APPS.GMD_SPEC_GRP dependencies on MTL_PARAMETERS

Line 111: FROM mtl_parameters

107: and entity_type = 'S';
108:
109: CURSOR c_orgn (p_organization_id NUMBER) IS
110: SELECT 1
111: FROM mtl_parameters
112: WHERE organization_id = p_Organization_id;
113:
114:
115: CURSOR c_owner(p_owner_id NUMBER) IS

Line 249: -- Check that Owner Organization id exist in MTL_PARAMETERS

245: IF (p_spec_header.owner_organization_id IS NULL) THEN
246: GMD_API_PUB.Log_Message('GMD_SPEC_ORGN_REQD');
247: RAISE FND_API.G_EXC_ERROR;
248: ELSE
249: -- Check that Owner Organization id exist in MTL_PARAMETERS
250: OPEN c_orgn(p_spec_header.owner_organization_id);
251: FETCH c_orgn INTO dummy;
252: IF c_orgn%NOTFOUND THEN
253: CLOSE c_orgn;

Line 823: FROM mtl_parameters

819: IF NOT spec_owner_orgn_valid(fnd_global.resp_id,
820: p_spec_header.owner_organization_id) THEN
821: -- Peep...Peep...Security Alert. User does not have access to Owner Organization
822: SELECT organization_code INTO l_owner_organization_code
823: FROM mtl_parameters
824: WHERE organization_id = p_spec_header.owner_organization_id;
825: GMD_API_PUB.Log_Message('GMD_USER_ORGN_NO_ACCESS',
826: 'OWNER', l_owner,
827: 'ORGN', l_owner_organization_code);