DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on MTL_PARAMETERS

Line 2295: --{{get needed information from mtl_parameters setup for EPC generation }}

2291: END IF;
2292:
2293: DBMS_MGD_ID_UTL.refresh_category(DBMS_MGD_ID_UTL.get_category_id('EPC', NULL));
2294:
2295: --{{get needed information from mtl_parameters setup for EPC generation }}
2296: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
2297: IF (l_debug = 1) THEN
2298: trace(p_org_id || 'is an invalid organization id');
2299: END IF;

Line 3800: --{{get needed information from mtl_parameters setup for EPC generation }}

3796:
3797: END IF;
3798:
3799:
3800: --{{get needed information from mtl_parameters setup for EPC generation }}
3801: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
3802: IF (l_debug = 1) THEN
3803: trace(p_org_id || 'is an invalid organization id');
3804: END IF;

Line 4376: FROM mtl_parameters

4372:
4373: BEGIN
4374: SELECT 1
4375: INTO l_is_epc_enabled
4376: FROM mtl_parameters
4377: WHERE organization_id = p_org_id
4378: AND Nvl(epc_generation_enabled_flag, 'N') = 'Y';
4379: EXCEPTION
4380: WHEN no_data_found then