81: IF (X_eng_item_id = X_mfg_item_id) THEN
82:
83: X_stmt_num := 100;
84: BEGIN
85: UPDATE MTL_SYSTEM_ITEMS
86: SET ENG_ITEM_FLAG = 'N',
87: --DESCRIPTION = X_mfg_description,
88: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),
89:
129:
130: IF (X_master_org <> X_org_id) THEN
131: X_stmt_num := 102;
132: BEGIN
133: UPDATE MTL_SYSTEM_ITEMS
134: SET ENG_ITEM_FLAG = 'N',
135: --DESCRIPTION = X_mfg_description,
136: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),
137:
182: -- item id has not changed
183:
184: IF (X_eng_item_id <> X_mfg_item_id) THEN
185:
186: -- Copy rows for MTL_SYSTEM_ITEMS
187:
188: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
189: X_org_id,
190: X_eng_item_id,
184: IF (X_eng_item_id <> X_mfg_item_id) THEN
185:
186: -- Copy rows for MTL_SYSTEM_ITEMS
187:
188: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
189: X_org_id,
190: X_eng_item_id,
191: X_mfg_item_id,
192: -1,
327: -- organization. If not, it needs to be created.
328:
329: IF (X_master_org <> X_org_id) THEN
330:
331: -- Copy rows for MTL_SYSTEM_ITEMS for the master org
332:
333: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
334: X_master_org,
335: X_eng_item_id,
329: IF (X_master_org <> X_org_id) THEN
330:
331: -- Copy rows for MTL_SYSTEM_ITEMS for the master org
332:
333: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
334: X_master_org,
335: X_eng_item_id,
336: X_mfg_item_id,
337: -1,
551:
552: X_GTIN_ST_TYPE_ID := Get_GTIN_Structure_Type_Id;
553:
554: BEGIN
555: UPDATE MTL_SYSTEM_ITEMS
556: SET ENG_ITEM_FLAG = 'N'
557: WHERE ORGANIZATION_ID = X_org_id
558: AND ENG_ITEM_FLAG <> 'N'
559: AND INVENTORY_ITEM_ID IN
587:
588: X_stmt_num := 200;
589:
590: BEGIN
591: UPDATE MTL_SYSTEM_ITEMS
592: SET ENG_ITEM_FLAG = 'N'
593: WHERE ORGANIZATION_ID = X_org_id
594: AND ENG_ITEM_FLAG <> 'N'
595: AND INVENTORY_ITEM_ID IN
641:
642: IF (X_master_org <> X_org_id) THEN
643: X_stmt_num := 200;
644: BEGIN
645: UPDATE MTL_SYSTEM_ITEMS
646: SET ENG_ITEM_FLAG = 'N'
647: WHERE ORGANIZATION_ID = X_master_org
648: AND ENG_ITEM_FLAG <> 'N'
649: AND INVENTORY_ITEM_ID IN