APPS.INV_LOC_WMS_PUB dependencies on MTL_PARAMETERS

Line 555: FROM mtl_parameters

551:
552: BEGIN
553: SELECT enforce_locator_alis_unq_flag
554: INTO l_org_alias_uniqueness
555: FROM mtl_parameters
556: WHERE organization_id = l_organization_id;
557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 580: FROM mtl_parameters

576: SELECT organization_id,
577: enforce_locator_alis_unq_flag
578: INTO l_organization_id,
579: l_org_alias_uniqueness
580: FROM mtl_parameters
581: WHERE organization_code = p_organization_code;
582:
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN

Line 1415: FROM mtl_parameters

1411:
1412: BEGIN
1413: SELECT enforce_locator_alis_unq_flag
1414: INTO l_org_alias_uniqueness
1415: FROM mtl_parameters
1416: WHERE organization_id = l_organization_id;
1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN
1419: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 1439: FROM mtl_parameters

1435: SELECT organization_id,
1436: enforce_locator_alis_unq_flag
1437: INTO l_organization_id,
1438: l_org_alias_uniqueness
1439: FROM mtl_parameters
1440: WHERE organization_code = p_organization_code;
1441: EXCEPTION
1442: WHEN NO_DATA_FOUND THEN
1443: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 2088: FROM mtl_parameters

2084: ELSE
2085: BEGIN
2086: SELECT organization_id
2087: INTO l_organization_id
2088: FROM mtl_parameters
2089: WHERE organization_code = p_organization_code;
2090: EXCEPTION
2091: WHEN NO_DATA_FOUND THEN
2092: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 2396: FROM mtl_parameters

2392: SELECT 1
2393: INTO l_chk_org
2394: FROM DUAL
2395: WHERE EXISTS(SELECT 1
2396: FROM mtl_parameters
2397: WHERE organization_id = p_organization_id);
2398:
2399: l_organization_id := p_organization_id;
2400: ELSE

Line 2409: FROM mtl_parameters

2405: RAISE fnd_api.g_exc_error;
2406: ELSE
2407: SELECT organization_id
2408: INTO l_organization_id
2409: FROM mtl_parameters
2410: WHERE organization_code = p_organization_code;
2411: END IF;
2412: END IF;
2413: