DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_MATERIAL_STATUS_HISTORY_S

Line 264: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval

260: -- g_eres_enabled varchar2(1):= 'Y';
261:
262: BEGIN
263: --BEGIN SCHANDRU INVERES
264: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
265: Into l_status_update_id
266: From dual;
267: -- END SCHANDRU INVERES
268: l_status_rec := p_status_rec;

Line 317: --MTL_MATERIAL_STATUS_HISTORY_S.nextval

313: -- NSRIVAST, INVCONV , End
314: )
315: VALUES (
316: -- BEGIN SCHANDRU INVERES
317: --MTL_MATERIAL_STATUS_HISTORY_S.nextval
318: l_status_update_id, -- Add this local variable so that it can be used to be stored in the temp table.
319: -- END SCHANDRU INVERES
320: l_status_rec.ORGANIZATION_ID
321: ,l_status_rec.INVENTORY_ITEM_ID

Line 378: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval

374: p_status_rec.serial_number <> p_status_rec.to_serial_number then
375: l_to_serial_number := p_status_rec.to_serial_number;
376: FOR cc IN cur_serial_number LOOP
377: -- BEGIN SCHANDRU INVERES
378: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
379: Into l_status_update_id
380: From dual;
381:
382: -- END SCHANDRU INVERES

Line 429: --MTL_MATERIAL_STATUS_HISTORY_S.nextval

425: -- NSRIVAST, INVCONV , End
426: )
427: VALUES (
428: --BEGIN SCHANDRU INVERES
429: --MTL_MATERIAL_STATUS_HISTORY_S.nextval
430: l_status_update_id, -- Add this local variable so that it can be used to be stored in the temp table
431: -- END SCHANDRU INVERES
432: l_status_rec.ORGANIZATION_ID
433: ,l_status_rec.INVENTORY_ITEM_ID