[Home] [Help]
225: DECLARE
226: --
227: CURSOR L_Item_Csr(org NUMBER, id NUMBER) IS
228: SELECT *
229: FROM mtl_system_items
230: WHERE
231: organization_id = org
232: AND inventory_item_id = id;
233: --
1402: -- IS specified AND the input parameter are populated.
1403: -- E.g. IF the item IS under lot control, so the lot NUMBER
1404: -- must be populated.
1405: -- The control information will be selected FROM the TABLE
1406: -- MTL_SYSTEM_ITEMS, but IF the global variables OF the
1407: -- package MTL_CCEOI_VAR_PVT are populated, no selection
1408: -- IS neccessary.
1409: -- Parameters:
1410: -- IN :
1468: SELECT
1469: location_control_code,
1470: serial_number_control_code,
1471: revision_qty_control_code,
1472: lot_control_code FROM mtl_system_items
1473: WHERE
1474: inventory_item_id = id
1475: and organization_id = org;
1476: --
1503: MDEBUG( 'Validating all control ');
1504: MDEBUG( 'Validating all control-Loc '||to_char(p_locator_rec.locator_id));
1505: MDEBUG( 'Validating all control -Rev'||p_revision);
1506: END IF;
1507: -- SELECT information FROM MTL_SYSTEM_ITEMS
1508: FOR x IN L_ItemCtrlInfo_Csr(p_inventory_item_id,
1509: p_organization_id) LOOP
1510: IF (l_debug = 1) THEN
1511: MDEBUG( 'Loc Ctrl1'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1923: -- This PROCEDURE validates the item information AND store the control
1924: -- information to package variables.
1925: -- The id takes presedence over the concatenated segment, which
1926: -- takes presedence over the individual segments. IS the item present
1927: -- IN the TABLE mtl_system_items, it will be checked IF it IS present IN TABLE
1928: -- mtl_cycle_count_items.
1929: -- Parameters:
1930: -- IN :
1931: -- p_api_version IN NUMBER (required)