DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on MTL_PARAMETERS

Line 171: * organization_id using MTL_PARAMETERS.

167: /********************************************************************
168: * Function : Organization
169: * Returns : NUMBER
170: * Purpose : Will convert the value of organization_code to
171: * organization_id using MTL_PARAMETERS.
172: * If the conversion fails then the function will return
173: * a NULL otherwise will return the org_id.
174: * For an unexpected error function will return a
175: * missing value.

Line 187: FROM mtl_parameters

183: l_err_text VARCHAR2(2000);
184: BEGIN
185: SELECT organization_id
186: INTO l_id
187: FROM mtl_parameters
188: WHERE organization_code = p_organization;
189:
190: RETURN l_id;
191: