DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on MTL_PARAMETERS

Line 247: p_organization_id IN mtl_parameters.organization_id%TYPE

243: /************************************/
244: /* SECTION 2: Defaulting from codes */
245: /************************************/
246: FUNCTION get_org_id_from_inv_org_id(
247: p_organization_id IN mtl_parameters.organization_id%TYPE
248: )
249: RETURN rcv_headers_interface.org_id%TYPE IS
250: x_org_id rcv_headers_interface.org_id%TYPE;
251: BEGIN

Line 510: FROM mtl_parameters

506: END IF;
507:
508: SELECT organization_id
509: INTO x_org_id
510: FROM mtl_parameters
511: WHERE organization_code = p_org_code;
512:
513: RETURN x_org_id;
514: EXCEPTION

Line 540: mtl_parameters org

536:
537: SELECT org.organization_id
538: INTO x_org_id
539: FROM hr_locations hl,
540: mtl_parameters org
541: WHERE hl.location_id = p_location_id
542: AND hl.inventory_organization_id = org.organization_id;
543:
544: RETURN x_org_id;