1280: /***************************************************************************
1281: * Function : Organization
1282: * Returns : NUMBER
1283: * Purpose : Will convert the value of organization_code to organization_id
1284: * using MTL_PARAMETERS.
1285: * If the conversion fails then the function will return a NULL
1286: * otherwise will return the org_id. For an unexpected error
1287: * function will return a missing value.
1288: ****************************************************************************/
1297: BEGIN
1298:
1299: SELECT organization_id
1300: INTO l_id
1301: FROM mtl_parameters
1302: WHERE organization_code = p_organization;
1303:
1304: RETURN l_id;
1305: