[Home] [Help]
1251: END IF;
1252:
1253: END IF;
1254:
1255: update pos_asn_shop_cart_details asnd
1256: set asnd.INTERFACE_TRANSACTION_ID = l_line_id,
1257: asnd.HEADER_INTERFACE_ID = c_rec.HEADER_ID
1258: where asnd.session_id = l_session_id and
1259: asnd.asn_line_id = c_rec.asn_line_id and
1259: asnd.asn_line_id = c_rec.asn_line_id and
1260: asnd.asn_line_split_id = c_rec.asn_line_split_id;
1261:
1262: -- Bug 1345768. Document_line_num is required by the pre-processor but is
1263: -- not available from pos_asn_shop_cart_details.
1264: update rcv_transactions_interface
1265: set DOCUMENT_LINE_NUM =
1266: (select LINE_NUM
1267: from po_lines_all
1283: where line_location_id = c_rec.PO_LINE_LOCATION_ID)
1284: where INTERFACE_TRANSACTION_ID = l_line_id;
1285:
1286: -- Dest subinventory is required by the pre-processor but is
1287: -- not available from pos_asn_shop_cart_details.
1288: update rcv_transactions_interface
1289: set SUBINVENTORY =
1290: (select destination_subinventory
1291: from po_distributions_all
1372:
1373: buyer_notify;
1374:
1375: delete from pos_asn_shop_cart_headers where session_id = l_session_id;
1376: delete from pos_asn_shop_cart_details where session_id = l_session_id;
1377:
1378: -- The pre-processor has already created the header record, also we do not want the
1379: -- pre-processor to be run again, so delete the header in the interface. If there is
1380: -- no header record in the interface table, the pre-processor is not run. The status
1433: -- Update all the info ---
1434:
1435: FOR l_counter IN 1..pos_asn_line_id.count LOOP
1436:
1437: update pos_asn_shop_cart_details set
1438: quantity_shipped = fnd_number.canonical_to_number(nvl(rtrim(ltrim(pos_quantity_shipped(l_counter))), 0)),
1439: unit_of_measure = pos_unit_of_measure(l_counter),
1440: comments = pos_comments(l_counter),
1441: wip_job_info = pos_osp_job.get_wip_info(pos_po_distribution_id(l_counter)),
1455: IF pos_submit = 'DELETE' AND pos_select.count > 0 THEN
1456:
1457: FOR l_counter IN 1..pos_select.count LOOP
1458:
1459: delete from pos_asn_shop_cart_details
1460: where session_id = l_session_id and
1461: asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
1462: asn_line_split_id = pos_asn_line_split_id(to_number(pos_select(l_counter)));
1463:
1464: END LOOP;
1465:
1466: select count(*)
1467: into d_count
1468: from pos_asn_shop_cart_details
1469: where session_id = l_session_id;
1470:
1471: IF d_count = 0 THEN
1472: delete from pos_asn_shop_cart_headers where session_id = l_session_id;
1479: IF pos_submit = 'EXPLODE' AND pos_select.count > 0 THEN
1480:
1481: FOR l_counter IN 1..pos_select.count LOOP
1482:
1483: update pos_asn_shop_cart_details set
1484: asn_line_split_id = asn_line_split_id + 1
1485: where session_id = l_session_id and
1486: asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
1487: asn_line_split_id > pos_asn_line_split_id(to_number(pos_select(l_counter)));
1486: asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
1487: asn_line_split_id > pos_asn_line_split_id(to_number(pos_select(l_counter)));
1488:
1489:
1490: insert into pos_asn_shop_cart_details
1491: (session_id,
1492: asn_line_id,
1493: asn_line_split_id,
1494: po_header_id,
1510: last_update_date,
1511: last_updated_by,
1512: unit_of_measure,
1513: item_id
1514: from pos_asn_shop_cart_details
1515: where session_id = l_session_id and
1516: asn_line_id = pos_asn_line_id(to_number(pos_select(l_counter))) and
1517: asn_line_split_id = pos_asn_line_split_id(to_number(pos_select(l_counter)));
1518: