[Home] [Help]
337: -- pass that to quality. So using that if it is generated.
338: IF l_rcv_transaction_rec.interface_transaction_id IS NOT NULL THEN
339: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
340: ELSE
341: SELECT rcv_transactions_interface_s.NEXTVAL
342: INTO l_interface_transaction_id
343: FROM DUAL;
344: END IF;
345:
737:
738: -- insert this record into RTI
739: -- Insert the row into the interface table using
740: -- the table handler call for the
741: -- rcv_transactions_interface table
742:
743: -- For inter-org shipment and ASN receipt, shipment header id is set already
744: -- For Normal PO, we generate a shipment header id at this point,
745: -- then use the same when actually inserting record into RSH.
892: END IF;
893: END IF;
894: print_debug('l_express_transaction: ' || l_express_transaction,4);
895: -- bug 4697949 end
896: INSERT INTO rcv_transactions_interface
897: (
898: interface_transaction_id
899: , GROUP_ID
900: , last_update_date
1272: INTO v_lcm_ship_line_id, v_unit_landed_cost
1273: FROM rcv_shipment_lines
1274: WHERE shipment_line_id = l_shipment_line_id;
1275:
1276: UPDATE rcv_transactions_interface
1277: SET lcm_shipment_line_id = v_lcm_ship_line_id,
1278: unit_landed_cost = v_unit_landed_cost
1279: WHERE interface_transaction_id = l_interface_transaction_id
1280: AND to_organization_id = l_to_org_id;
1279: WHERE interface_transaction_id = l_interface_transaction_id
1280: AND to_organization_id = l_to_org_id;
1281:
1282: ELSE
1283: UPDATE rcv_transactions_interface
1284: SET processing_status_code = 'LC_PENDING',
1285: PROCESSING_MODE_CODE = 'BATCH'
1286: WHERE interface_transaction_id = l_interface_transaction_id
1287: AND to_organization_id = l_to_org_id;
1294: BEGIN
1295: SELECT secondary_uom_code, secondary_unit_of_measure,
1296: secondary_quantity
1297: INTO t_sec_uom_code, t_sec_uom, t_sec_qty
1298: FROM rcv_transactions_interface
1299: WHERE interface_transaction_id = l_interface_transaction_id;
1300: print_debug('t_sec_uom_code ' || t_sec_uom_code, 1);
1301: print_debug('t_sec_uom ' || t_sec_uom, 1);
1302: print_debug('t_sec_qty ' || t_sec_qty, 1);
2155: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
2156: l_qa_routing_id := 2;
2157:
2158: BEGIN
2159: SELECT rcv_transactions_interface_s.NEXTVAL
2160: INTO l_rcv_transaction_rec.interface_transaction_id
2161: FROM DUAL;
2162:
2163: l_progress := '83';
4480: l_rcv_rcpt_rec.inspection_required_flag := 'Y';
4481: l_rcv_rcpt_rec.routing_id := 2;
4482:
4483: BEGIN
4484: SELECT rcv_transactions_interface_s.NEXTVAL
4485: INTO l_rcv_transaction_rec.interface_transaction_id
4486: FROM DUAL;
4487:
4488: l_progress := '83';
5515: /* Group BY LPN_ID is changed for Express Receipts */
5516: /* Also duplicate print of LPN labels is avoided */
5517: CURSOR c_rti_txn_id IS
5518: SELECT MAX(rti.interface_transaction_id)
5519: FROM rcv_transactions_interface rti
5520: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5521: GROUP BY DECODE(p_source_type,
5522: 'ASNEXP', rti.interface_transaction_id
5523: , 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
6192: , TO_NUMBER(NULL)
6193: , mtln.secondary_transaction_quantity --OPM Convergence
6194: FROM mtl_material_transactions mmt
6195: , mtl_transaction_lot_numbers mtln
6196: , rcv_transactions rt
6197: , rcv_shipment_lines rsl
6198: , mtl_system_items msi
6199: WHERE rt.interface_transaction_id = p_txn_source_id
6200: AND mmt.rcv_transaction_id = rt.transaction_id
6203: OR(rt.transaction_type = 'CORRECT'
6204: AND rt.quantity < 0))
6205: AND msi.lot_control_code = 2
6206: AND EXISTS(SELECT 1
6207: FROM rcv_transactions rt1
6208: WHERE rt1.transaction_id = rt.parent_transaction_id
6209: AND rt1.transaction_type = 'DELIVER')
6210: AND rt.user_entered_flag = 'Y'
6211: AND rsl.shipment_line_id = rt.shipment_line_id
6352: BEGIN
6353:
6354: SELECT PROCESSING_STATUS_CODE
6355: INTO v_processing_status_code
6356: FROM RCV_TRANSACTIONS_INTERFACE
6357: WHERE HEADER_INTERFACE_ID in
6358: (SELECT HEADER_INTERFACE_ID
6359: FROM RCV_HEADERS_INTERFACE
6360: WHERE receipt_num = p_lcmReceiptNum
6916: END IF;
6917:
6918: SELECT transaction_status_code
6919: INTO l_process_status
6920: FROM rcv_transactions_interface
6921: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
6922: AND ROWNUM = 1;
6923: ELSE
6924: SELECT transaction_status_code
6922: AND ROWNUM = 1;
6923: ELSE
6924: SELECT transaction_status_code
6925: INTO l_process_status
6926: FROM rcv_transactions_interface
6927: WHERE shipment_header_id = g_shipment_header_id
6928: AND ROWNUM < 2;
6929: END IF;
6930:
6952: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6953: IF (l_debug = 1) THEN
6954: print_debug('Calling to insert RHI for J code', 4);
6955: END IF;
6956: UPDATE rcv_transactions_interface
6957: SET shipment_num = p_shipment_num
6958: , freight_carrier_code = p_freight_carrier_code
6959: , bill_of_lading = p_bill_of_lading
6960: , packing_slip = p_packing_slip
6961: , num_of_containers = p_num_of_containers
6962: , waybill_airbill_num = p_waybill_airbill_num
6963: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
6964: ELSE
6965: UPDATE rcv_transactions_interface
6966: SET shipment_num = p_shipment_num
6967: , freight_carrier_code = p_freight_carrier_code
6968: , bill_of_lading = p_bill_of_lading
6969: , packing_slip = p_packing_slip
7540: l_counter NUMBER := 0;
7541: l_receipt_number VARCHAR2(30);
7542: CURSOR c_rti_txn_id(p_shipment_header_id NUMBER) IS
7543: SELECT rti.interface_transaction_id
7544: FROM rcv_transactions_interface rti
7545: WHERE rti.shipment_header_id = p_shipment_header_id;
7546: BEGIN
7547: l_progress := '10';
7548: l_receipt_number := p_receipt_num; --bug 3630412
9115: SELECT count(1)
9116: INTO l_partial_rcpt
9117: FROM dual
9118: WHERE EXISTS ( SELECT 1
9119: FROM rcv_transactions
9120: WHERE shipment_header_id = p_shipment_header_id
9121: AND organization_id = p_rcv_org_id
9122: );
9123: EXCEPTION
9130: SELECT count(1)
9131: INTO l_partial_rcpt
9132: FROM dual
9133: WHERE EXISTS ( SELECT 1
9134: FROM rcv_transactions_interface
9135: WHERE shipment_header_id = p_shipment_header_id
9136: AND to_organization_id = p_rcv_org_id
9137: );
9138: EXCEPTION
9262: BEGIN
9263: SELECT NVL(SUM(mtli.primary_quantity),0)
9264: INTO l_mtli_primary_quantity
9265: FROM mtl_transaction_lots_interface mtli,
9266: rcv_transactions_interface rti
9267: WHERE rti.processing_status_code <> 'ERROR'
9268: AND rti.transaction_status_code <> 'ERROR'
9269: AND rti.to_organization_id = p_rcv_org_id
9270: AND rti.item_id = p_inventory_item_id
9381: BEGIN
9382: SELECT NVL(SUM(mtli.primary_quantity),0)
9383: INTO l_mtli_primary_quantity
9384: FROM mtl_transaction_lots_interface mtli,
9385: rcv_transactions_interface rti
9386: WHERE rti.processing_status_code <> 'ERROR'
9387: AND rti.transaction_status_code <> 'ERROR'
9388: AND rti.to_organization_id = p_rcv_org_id
9389: AND rti.item_id = p_inventory_item_id