APPS.RCV_ASN_TRX_INSERT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 27: /* Delete only once from the rcv_transactions_interface table for every

23:
24: V_CURRENT_INTERFACE_ID := -999;
25: V_PRIOR_INTERFACE_ID := -999;
26:
27: /* Delete only once from the rcv_transactions_interface table for every
28: group of pl/sql table rows that have the same interface id */
29:
30:
31: FOR j in i..E_O_T loop

Line 59: ASN_DEBUG.PUT_LINE('delete from rcv_transactions_interface rowid ' || V_TRANS_TAB(j).ROW_ID);

55:
56: IF V_CURRENT_INTERFACE_ID <> V_PRIOR_INTERFACE_ID then
57:
58: ASN_DEBUG.PUT_LINE('Handle the original interface id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
59: ASN_DEBUG.PUT_LINE('delete from rcv_transactions_interface rowid ' || V_TRANS_TAB(j).ROW_ID);
60:
61: RCV_TRX_INTERFACE_DELETE_PKG.Delete_Row(V_TRANS_TAB(j).ROW_ID);
62:
63: /* V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID := NULL; */ -- need to maintain the interface transaction id

Line 270: ASN_DEBUG.PUT_LINE('insert into rcv_transactions_interface with new id ');

266: V_TRANS_TAB.delete(j);
267:
268: ELSE
269:
270: ASN_DEBUG.PUT_LINE('insert into rcv_transactions_interface with new id ');
271:
272: /* Since we are inserting 1-> many rows need to generate a new interface id */
273:
274: V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID := NULL;

Line 509: delete from rcv_transactions_interface

505: -- delete any asn lines that have been sent
506:
507: asn_debug.put_line('Delete any asn lines that have been sent');
508:
509: delete from rcv_transactions_interface
510: where header_interface_id = v_header_record.header_record.header_interface_id;
511:
512: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
513:

Line 512: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface

508:
509: delete from rcv_transactions_interface
510: where header_interface_id = v_header_record.header_record.header_interface_id;
511:
512: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
513:
514: -- Make sure we don't inset cancelled lines and lines that are waiting to
515: -- be cancelled in rti
516: -- The transaction processor will then cancel the lines

Line 521: INSERT INTO RCV_TRANSACTIONS_INTERFACE

517:
518: -- Bug 587603 Inserting processing request id for CANCEL otherwise
519: -- transaction processor will not look at it.
520:
521: INSERT INTO RCV_TRANSACTIONS_INTERFACE
522: (Interface_Transaction_Id ,
523: Header_interface_id ,
524: Group_Id ,
525: Last_Update_Date ,

Line 555: RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

551: SHIPMENT_LINE_ID,
552: DESTINATION_TYPE_CODE,
553: processing_request_id)
554: SELECT
555: RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
556: V_header_record.header_record.header_interface_id,
557: V_header_record.header_record.group_id,
558: V_header_record.header_record.last_update_date,
559: V_header_record.header_record.last_updated_by,

Line 590: not exists (select 'x' from rcv_transactions_interface rti

586: rsl.destination_type_code, V_header_record.header_record.processing_request_id
587: FROM rcv_shipment_lines rsl
588: WHERE rsl.shipment_header_id = V_header_record.header_record.receipt_header_id and
589: rsl.shipment_line_status_code <> 'CANCELLED' and
590: not exists (select 'x' from rcv_transactions_interface rti
591: where
592: rti.shipment_line_id = rsl.shipment_line_id and
593: rti.shipment_header_id = rsl.shipment_header_id and
594: rti.transaction_type = 'CANCEL' and