[Home] [Help]
150: IS
151: l_revised_item_seq_id NUMBER := NULL;
152: BEGIN
153:
154: SELECT eng_revised_items_s.NEXTVAL
155: INTO l_revised_item_seq_id
156: FROM DUAL;
157:
158: RETURN l_revised_item_seq_id;
408:
409: CURSOR c_rev_item_status (cp_rev_item_seq_id IN NUMBER)
410: IS
411: SELECT status_code ,status_type
412: FROM eng_revised_items
413: WHERE revised_item_sequence_id = cp_rev_item_seq_id;
414:
415: BEGIN
416:
696: END IF;
697: --
698: -- Added for bug fix 4517503
699: -- Setting the from item revision id to current item revision id
700: -- In ENGURITB.pls this value is being used to populate eng_revised_items.
701: -- current_item_revision_id in procedure insert_row.
702: -- Moved from ENGURITB.pls => Eng_revised_item_util.Insert_Row
703: IF g_rev_item_unexp_rec.from_item_revision_id IS NULL OR
704: g_rev_item_unexp_rec.from_item_revision_id = FND_API.G_MISS_NUM
1268: AND planned_organization = p_organization_id
1269: )
1270: );
1271: BEGIN
1272: l_sequence_id := ENG_REVISED_ITEMS_PKG.Get_BOM_Lists_Seq_Id;
1273:
1274: ENG_REVISED_ITEMS_PKG.Insert_BOM_Lists
1275: ( X_Revised_Item_Id => p_revised_item_id
1276: , X_Sequence_Id => l_sequence_id
1270: );
1271: BEGIN
1272: l_sequence_id := ENG_REVISED_ITEMS_PKG.Get_BOM_Lists_Seq_Id;
1273:
1274: ENG_REVISED_ITEMS_PKG.Insert_BOM_Lists
1275: ( X_Revised_Item_Id => p_revised_item_id
1276: , X_Sequence_Id => l_sequence_id
1277: , X_Bill_Sequence_Id => p_bill_sequence_id
1278: );
1283: l_scheduled_date := l_sched_date.inventory_use_up_date;
1284: END IF;
1285: END LOOP;
1286:
1287: ENG_REVISED_ITEMS_PKG.Delete_BOM_Lists (X_Sequence_Id => l_sequence_id);
1288:
1289: RETURN l_scheduled_date;
1290:
1291: END Get_Scheduled_Date;