APPS.INV_LOC_WMS_PUB dependencies on MTL_PARAMETERS

Line 497: FROM mtl_parameters

493:
494: BEGIN
495: SELECT enforce_locator_alis_unq_flag
496: INTO l_org_alias_uniqueness
497: FROM mtl_parameters
498: WHERE organization_id = l_organization_id;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 522: FROM mtl_parameters

518: SELECT organization_id,
519: enforce_locator_alis_unq_flag
520: INTO l_organization_id,
521: l_org_alias_uniqueness
522: FROM mtl_parameters
523: WHERE organization_code = p_organization_code;
524:
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN

Line 1332: FROM mtl_parameters

1328:
1329: BEGIN
1330: SELECT enforce_locator_alis_unq_flag
1331: INTO l_org_alias_uniqueness
1332: FROM mtl_parameters
1333: WHERE organization_id = l_organization_id;
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 1356: FROM mtl_parameters

1352: SELECT organization_id,
1353: enforce_locator_alis_unq_flag
1354: INTO l_organization_id,
1355: l_org_alias_uniqueness
1356: FROM mtl_parameters
1357: WHERE organization_code = p_organization_code;
1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN
1360: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 1992: FROM mtl_parameters

1988: ELSE
1989: BEGIN
1990: SELECT organization_id
1991: INTO l_organization_id
1992: FROM mtl_parameters
1993: WHERE organization_code = p_organization_code;
1994: EXCEPTION
1995: WHEN NO_DATA_FOUND THEN
1996: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

Line 2300: FROM mtl_parameters

2296: SELECT 1
2297: INTO l_chk_org
2298: FROM DUAL
2299: WHERE EXISTS(SELECT 1
2300: FROM mtl_parameters
2301: WHERE organization_id = p_organization_id);
2302:
2303: l_organization_id := p_organization_id;
2304: ELSE

Line 2313: FROM mtl_parameters

2309: RAISE fnd_api.g_exc_error;
2310: ELSE
2311: SELECT organization_id
2312: INTO l_organization_id
2313: FROM mtl_parameters
2314: WHERE organization_code = p_organization_code;
2315: END IF;
2316: END IF;
2317: