[Home] [Help]
303: , Quantity
304: , Project_Id
305: , Task_Id
306: , Unit_Number
307: From oke_k_deliverables_b
308: Where Deliverable_Id = P_Deliverable_Id;
309:
310: recinfo l_csr%ROWTYPE;
311: cinfo C%ROWTYPE;
392: , task_id
393: , unit_number
394: , uom_code
395: , mps_transaction_id
396: From oke_k_deliverables_b
397: Where deliverable_id = p_deliverable_id
398: FOR UPDATE NOWAIT;
399: L_DRow_ID ROWID;
400: L_Item_ID NUMBER;
502: -- AND Organization_Id = L_Inv_Org_ID_Old
503: -- );
504: END IF;
505:
506: UPDATE oke_k_deliverables_b
507: SET po_ref_2 = 1
508: WHERE ROWID = L_DRow_ID;
509:
510: ELSE -- if record wasn't updated - insert it
524: );
525: IF l_mps_transaction_id IS NOT NULL THEN
526: x_out_id := l_mps_transaction_id;
527: -- update mps_transaction_id in deliverable table
528: UPDATE oke_k_deliverables_b
529: SET mps_transaction_id = l_mps_transaction_id
530: WHERE ROWID = L_DRow_ID;
531: END IF;
532: END IF;
625: ( C_deliverable_id number
626: , C_term_code varchar2
627: ) is
628: select kt1.term_value_pk1 term_value
629: from oke_k_deliverables_b d
630: , oke_k_terms kt1
631: , ( select cle_id , cle_id_ascendant , level_sequence from okc_ancestrys
632: union all
633: select id , id , 99999 from okc_k_lines_b ) a
640: order by decode(kt1.k_line_id , null , 0 , a.level_sequence) desc;
641:
642: CURSOR csr_dts_ship(p_id number) IS
643: SELECT shipping_request_id, in_process_flag, initiate_shipment_date
644: FROM oke_k_deliverables_b
645: WHERE deliverable_id = p_id
646: FOR UPDATE OF shipping_request_id, in_process_flag, initiate_shipment_date NOWAIT;
647:
648: CURSOR l_line_csr(p_id number) IS
670: , B.WEIGHT_UOM_CODE
671: , B.VOLUME
672: , B.VOLUME_UOM_CODE
673: FROM OKC_K_HEADERS_B H
674: , OKE_K_DELIVERABLES_B B
675: , OKE_K_DELIVERABLES_TL T
676: WHERE B.DELIVERABLE_ID = p_id
677: AND B.DELIVERABLE_ID = T.DELIVERABLE_ID
678: AND T.LANGUAGE = USERENV('LANG')
695: CURSOR csr_cust_item (p_deliverable_id NUMBER )
696: IS
697: SELECT l.customer_item_id, d.item_id, d.INVENTORY_ORG_ID
698: FROM oke_k_lines l,
699: oke_k_deliverables_b d
700: WHERE d.deliverable_id = p_deliverable_id
701: AND d.k_line_id = l.k_line_id
702: AND l.inventory_item_id = d.item_id;
703:
965: WSH_interface_pub.create_shipment_lines(l_ship_rec, l_id, l_return_status);
966:
967: if l_return_status = oke_api.g_ret_sts_success then
968: -- update deliverable table
969: update oke_k_deliverables_b
970: set shipping_request_id = l_id,
971: in_process_flag = 'Y',
972: initiate_shipment_date = sysdate
973: where CURRENT OF csr_dts_ship;
1111: where deliverable_id = p_deliverable_id;
1112:
1113: CURSOR csr_dts_req(p_id number) IS
1114: SELECT po_ref_1, in_process_flag
1115: FROM oke_k_deliverables_b
1116: WHERE deliverable_id = p_id
1117: FOR UPDATE OF po_ref_1, in_process_flag NOWAIT;
1118: /* Bug Number: 6011322 start */
1119: cursor req_c(p_id number, p_batch_id number) is
1218:
1219: CURSOR Header_C IS
1220: SELECT Buy_Or_Sell
1221: FROM okc_k_headers_b
1222: WHERE ID = (SELECT K_Header_ID FROM oke_k_deliverables_b WHERE Deliverable_ID = P_Deliverable_ID);
1223:
1224: BEGIN
1225: l_return_status := OKE_API.START_ACTIVITY(
1226: l_api_name,
1499: l_vendor_site_id,
1500: l_req_line_type_id,
1501: l_category_id,
1502: l_item_description
1503: from oke_k_deliverables_b d
1504: , okc_k_headers_b h
1505: , mtl_parameters mp
1506: , org_organization_definitions ood
1507: , oke_k_vers_numbers_v ver
1518: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Req created successfully, update deliverable table');
1519: END IF;
1520:
1521: -- update deliverable table
1522: update oke_k_deliverables_b
1523: set po_ref_1 = l_id
1524: , in_process_flag = 'Y'
1525: where CURRENT OF csr_dts_req;
1526:
1767: , L.line_number line_number
1768: , D.deliverable_num deliverable_num
1769: , D.description description
1770: , h.authoring_org_id org_id
1771: --bug 7390122 changed oke_k_deliverables_b to oke_k_deliverables_vl as it has description
1772: FROM oke_k_deliverables_vl D
1773: , okc_k_lines_b L
1774: , oke_k_headers_v H
1775: , oke_k_types_vl T
1784: , D.expenditure_type
1785: , D.expenditure_item_date
1786: , O.name expenditure_org
1787: , D.need_by_date
1788: FROM oke_k_deliverables_b D
1789: , hr_all_organization_units_tl O
1790: WHERE D.deliverable_id = p_id
1791: AND O.organization_id (+) = D.expenditure_organization_id
1792: AND O.language (+) = userenv('LANG');
1794:
1795: CURSOR c_ship (p_id number) IS
1796: SELECT D.ship_from_location_id
1797: , L.location_code ship_from_location
1798: FROM oke_k_deliverables_b D
1799: , hr_locations_all_tl L
1800: WHERE D.deliverable_id = p_id
1801: AND L.location_id = D.ship_from_location_id
1802: AND L.language = userenv('LANG');
2567: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
2568:
2569: CURSOR dlvbl_c IS
2570: SELECT k_header_id, uom_code, shipping_request_id
2571: FROM oke_k_deliverables_b
2572: where deliverable_id = p_deliverable_id;
2573:
2574: CURSOR cancel_qty_c IS
2575: SELECT Nvl(Sum(CANCELLED_QUANTITY),0)
2599: OPEN cancel_qty_c;
2600: FETCH cancel_qty_c INTO x_cancelled_qty;
2601: CLOSE cancel_qty_c;
2602: --bug 8320909 start
2603: UPDATE oke_k_deliverables_b
2604: SET quantity=quantity-x_cancelled_qty
2605: WHERE deliverable_id = p_deliverable_id;
2606: --bug 8320909 end
2607: ELSE