DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS

Line 85: UPDATE MTL_SYSTEM_ITEMS

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:

Line 133: UPDATE MTL_SYSTEM_ITEMS

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:

Line 186: -- Copy rows for MTL_SYSTEM_ITEMS

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,

Line 188: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_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,

Line 331: -- Copy rows for MTL_SYSTEM_ITEMS for the master org

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,

Line 333: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_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,

Line 555: UPDATE MTL_SYSTEM_ITEMS

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

Line 591: UPDATE MTL_SYSTEM_ITEMS

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

Line 645: UPDATE MTL_SYSTEM_ITEMS

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