555: RAISE OKE_API.G_Exception_Error;
556:
557: END IF;
558:
559: SELECT oke_k_deliverables_s.nextval
560: INTO l_id
561: FROM DUAL;
562:
563: OPEN c;
807: , unit_price
808: , currency_code
809: , quantity
810: , uom_code)
811: SELECT oke_k_deliverables_s.nextval
812: , sysdate
813: , fnd_global.user_id
814: , sysdate
815: , fnd_global.user_id
1620: AND SOURCE_DELIVERABLE_ID = P_SOURCE_DELIVERABLE_ID;
1621:
1622: BEGIN
1623:
1624: SELECT oke_k_deliverables_s.NEXTVAL INTO L_ID FROM DUAL;
1625:
1626: OPEN c;
1627: FETCH c INTO L_Deliverable_ID;
1628: CLOSE c;