APPS.GMD_SPEC_GRP dependencies on MTL_PARAMETERS

Line 126: FROM mtl_parameters

122: and entity_type = 'S';
123:
124: CURSOR c_orgn (p_organization_id NUMBER) IS
125: SELECT 1
126: FROM mtl_parameters
127: WHERE organization_id = p_Organization_id;
128:
129:
130: CURSOR c_owner(p_owner_id NUMBER) IS

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

260: IF (p_spec_header.owner_organization_id IS NULL) THEN
261: GMD_API_PUB.Log_Message('GMD_SPEC_ORGN_REQD');
262: RAISE FND_API.G_EXC_ERROR;
263: ELSE
264: -- Check that Owner Organization id exist in MTL_PARAMETERS
265: OPEN c_orgn(p_spec_header.owner_organization_id);
266: FETCH c_orgn INTO dummy;
267: IF c_orgn%NOTFOUND THEN
268: CLOSE c_orgn;

Line 865: FROM mtl_parameters

861: IF NOT spec_owner_orgn_valid(fnd_global.resp_id,
862: p_spec_header.owner_organization_id) THEN
863: -- Peep...Peep...Security Alert. User does not have access to Owner Organization
864: SELECT organization_code INTO l_owner_organization_code
865: FROM mtl_parameters
866: WHERE organization_id = p_spec_header.owner_organization_id;
867: GMD_API_PUB.Log_Message('GMD_USER_ORGN_NO_ACCESS',
868: 'OWNER', l_owner,
869: 'ORGN', l_owner_organization_code);