APPS.INVPUOPI dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 11: ** into SEGMENT columns in MTL_SYSTEM_ITEMS_INTERFACE

7: l_id_flex_num number(15) := 101;
8:
9: /*
10: ** Parse the input item number, assign segment values
11: ** into SEGMENT columns in MTL_SYSTEM_ITEMS_INTERFACE
12: */
13: ---Start: Bug Fix 3051653
14: G_SEGMENT_DELIMITER VARCHAR2(10) := NULL;
15: G_SEGMENTS_INUSE NUMBER(10) := NULL;

Line 72: G_DYNAMIC_UPDATE := ' UPDATE mtl_system_items_interface'||

68:
69:
70: IF G_DYNAMIC_UPDATE IS NULL THEN
71:
72: G_DYNAMIC_UPDATE := ' UPDATE mtl_system_items_interface'||
73: ' SET item_number = '||G_SEGMENT_STRING||
74: ' WHERE ROWID = :p_row_id '||
75: ' RETURNING inventory_item_id, item_number INTO :item_id, :item_number';
76: END IF;

Line 376: ** update segment values in MTL_SYSTEM_ITEMS_INTERFACE

372: END LOOP;
373: --End :3632767 Code to suport \. in item number
374:
375: /*
376: ** update segment values in MTL_SYSTEM_ITEMS_INTERFACE
377: */
378: update MTL_SYSTEM_ITEMS_INTERFACE
379: set segment1 = DECODE(seg_value(1),NULL,segment1,seg_value(1)),
380: segment2 = DECODE(seg_value(2),NULL,segment2,seg_value(2)),

Line 378: update MTL_SYSTEM_ITEMS_INTERFACE

374:
375: /*
376: ** update segment values in MTL_SYSTEM_ITEMS_INTERFACE
377: */
378: update MTL_SYSTEM_ITEMS_INTERFACE
379: set segment1 = DECODE(seg_value(1),NULL,segment1,seg_value(1)),
380: segment2 = DECODE(seg_value(2),NULL,segment2,seg_value(2)),
381: segment3 = DECODE(seg_value(3),NULL,segment3,seg_value(3)),
382: segment4 = DECODE(seg_value(4),NULL,segment4,seg_value(4)),

Line 619: from MTL_SYSTEM_ITEMS_INTERFACE

615: END IF;
616:
617: select INVENTORY_ITEM_ID
618: into flex_id
619: from MTL_SYSTEM_ITEMS_INTERFACE
620: where ORGANIZATION_ID = org_id
621: and NVL(segment1,' ') = DECODE(seg_value(1),NULL,' ',seg_value(1))
622: and NVL(segment2,' ') = DECODE(seg_value(2),NULL,' ',seg_value(2))
623: and NVL(segment3,' ') = DECODE(seg_value(3),NULL,' ',seg_value(3))

Line 943: mtl_system_items_interface_s.NEXTVAL,

939: )
940: VALUES
941: (
942: trans_id,
943: mtl_system_items_interface_s.NEXTVAL,
944: org_id,
945: l_sysdate,
946: user_id,
947: l_sysdate,