eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_TRANSACTION_PROCESSOR dependencies on RCV_TRANSACTIONS

Line 136: ( p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

132: RAISE;
133: END get_acct_period_status;
134:
135: PROCEDURE RVTTHIns
136: ( p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
137: , p_transaction_type IN RCV_TRANSACTIONS.transaction_type%TYPE
138: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE

Line 137: , p_transaction_type IN RCV_TRANSACTIONS.transaction_type%TYPE

133: END get_acct_period_status;
134:
135: PROCEDURE RVTTHIns
136: ( p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
137: , p_transaction_type IN RCV_TRANSACTIONS.transaction_type%TYPE
138: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE
141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE

Line 140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE

136: ( p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
137: , p_transaction_type IN RCV_TRANSACTIONS.transaction_type%TYPE
138: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE
141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE
142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE

Line 141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE

137: , p_transaction_type IN RCV_TRANSACTIONS.transaction_type%TYPE
138: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE
141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE
142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

Line 142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE

138: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE
141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE
142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

Line 143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE

139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE
141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE
142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

Line 144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE

140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE
141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE
142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

Line 145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

141: , p_primary_quantity IN RCV_TRANSACTIONS.primary_quantity%TYPE
142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

Line 146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

142: , p_source_doc_unit_of_measure IN RCV_TRANSACTIONS.source_doc_unit_of_measure%TYPE
143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
150: , x_error_message OUT NOCOPY VARCHAR2

Line 147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

143: , p_source_doc_quantity IN RCV_TRANSACTIONS.source_doc_quantity%TYPE
144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS

Line 148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

144: , p_parent_id IN RCV_TRANSACTIONS.transaction_id%TYPE
145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS
152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;

Line 149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE

145: , p_receive_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
146: , p_deliver_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
147: , p_correct_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS
152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;
153: l_parent_row RCV_TRANSACTIONS%ROWTYPE;

Line 152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;

148: , p_return_id IN OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS
152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;
153: l_parent_row RCV_TRANSACTIONS%ROWTYPE;
154: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
155:
156: l_use_ship_to_flag VARCHAR2(1);

Line 153: l_parent_row RCV_TRANSACTIONS%ROWTYPE;

149: , x_rt_id OUT NOCOPY RCV_TRANSACTIONS.transaction_id%TYPE
150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS
152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;
153: l_parent_row RCV_TRANSACTIONS%ROWTYPE;
154: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
155:
156: l_use_ship_to_flag VARCHAR2(1);
157: l_common_receiving BOOLEAN;

Line 154: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS
152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;
153: l_parent_row RCV_TRANSACTIONS%ROWTYPE;
154: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
155:
156: l_use_ship_to_flag VARCHAR2(1);
157: l_common_receiving BOOLEAN;
158:

Line 196: SELECT rcv_transactions_s.NEXTVAL

192: || ', p_correct_id: ' || p_correct_id
193: || ', p_return_id: ' || p_return_id
194: || ')');
195:
196: SELECT rcv_transactions_s.NEXTVAL
197: INTO l_rt_row.transaction_id
198: FROM DUAL;
199:
200: -- Bug 4401341

Line 205: use them to populate rcv_transactions table.

201: /*Commenting the rcv_table_functions.get_rti_frow_from_id call and fetching
202: the value from rti table as lpn_id fetched from the cache table does not
203: have the value that is updated by Inventory.There may be other fields that
204: would have got updated.So fetching all the values directly from rti and then
205: use them to populate rcv_transactions table.
206: */
207: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
208:
209: select *

Line 211: from rcv_transactions_interface

207: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
208:
209: select *
210: into l_rti_row
211: from rcv_transactions_interface
212: where interface_transaction_id = p_rti_id;
213:
214:
215: /*start of bug 13394743:get the latest price from PLL for PO transaction*/

Line 245: update rcv_transactions_interface

241: -- Change the price for this transaction
242: l_rti_row.po_unit_price := l_po_unit_price;
243:
244: -- Change price for later when calculate trx_cost when insert MMTT in rvtii
245: update rcv_transactions_interface
246: set po_unit_price = l_po_unit_price
247: where interface_transaction_id = l_rti_row.interface_transaction_id;
248: END IF;
249: END IF;

Line 516: FROM rcv_transactions

512: --bug8920533
513: IF l_rt_row.country_of_origin_code IS NULL AND l_rt_row.source_document_code = 'PO' AND l_rt_row.parent_transaction_id IS NOT NULL AND l_rt_row.parent_transaction_id > 0 THEN
514: SELECT country_of_origin_code
515: INTO l_rt_row.country_of_origin_code
516: FROM rcv_transactions
517: WHERE transaction_id = l_rt_row.parent_transaction_id;
518: END IF;
519: --end bug 8920533
520: l_rt_row.oe_order_header_id := l_rti_row.oe_order_header_id;

Line 535: --rcv_transactions table.

531: END IF;
532: ELSE
533: --Bug 4401341 : If transaction_type is 'SHIP' and auto_transact_code is
534: --'RECEIVE', then we stamp the lpn_id and transfer_lpn_id columns in
535: --rcv_transactions table.
536: IF p_transaction_type = 'DELIVER' AND
537: l_rti_row.transaction_type = 'RECEIVE'
538: THEN
539: l_rt_row.lpn_id := l_rti_row.transfer_lpn_id;

Line 629: INSERT INTO RCV_TRANSACTIONS

625: );
626:
627: /* GSCC errors come up when we use the foll. insert.
628: * Changing to use the full insert stmts.
629: INSERT INTO RCV_TRANSACTIONS
630: VALUES l_rt_row;
631: */
632: /* Bug: 6487371
633: * Added exception handler to catch the exception when insertion into rcv_transactions

Line 633: * Added exception handler to catch the exception when insertion into rcv_transactions

629: INSERT INTO RCV_TRANSACTIONS
630: VALUES l_rt_row;
631: */
632: /* Bug: 6487371
633: * Added exception handler to catch the exception when insertion into rcv_transactions
634: * fails due to exception raised in the triggers(for eg; India Localisation triggers) on
635: * rcv_transactions table. Similarly added exception handler for insertion into
636: * po_note_references table. To this rvthinns() function as whole, added one exception handler.
637: * While storing sqlerrm in the x_message_data getting only the first 200 bytes.

Line 635: * rcv_transactions table. Similarly added exception handler for insertion into

631: */
632: /* Bug: 6487371
633: * Added exception handler to catch the exception when insertion into rcv_transactions
634: * fails due to exception raised in the triggers(for eg; India Localisation triggers) on
635: * rcv_transactions table. Similarly added exception handler for insertion into
636: * po_note_references table. To this rvthinns() function as whole, added one exception handler.
637: * While storing sqlerrm in the x_message_data getting only the first 200 bytes.
638: * without that unhandled exception is raised while copying the sqlerrm. And moreover
639: * in rvtth.lpc rvthinns(), x_msg_data is defined to store only 200 bytes.

Line 642: INSERT INTO rcv_transactions

638: * without that unhandled exception is raised while copying the sqlerrm. And moreover
639: * in rvtth.lpc rvthinns(), x_msg_data is defined to store only 200 bytes.
640: */
641: BEGIN --Bug: 6487371
642: INSERT INTO rcv_transactions
643: (transaction_id,
644: last_update_date,
645: last_updated_by,
646: created_by,

Line 882: asn_debug.put_line('Error occured while inserting into rcv_transactions...'||sqlerrm);

878: l_rt_row.unit_landed_cost, -- lcm changes
879: decode(l_rt_row.lcm_shipment_line_id, null, null,nvl(l_rt_row.lcm_adjustment_num,0)) );--changes for LCM-OPM integration project
880: EXCEPTION --Bug: 6487371
881: when others then
882: asn_debug.put_line('Error occured while inserting into rcv_transactions...'||sqlerrm);
883: x_error_message := substr(sqlerrm,1,200);
884: RETURN;
885: END;--Bug: 6487371
886:

Line 902: UPDATE rcv_transactions_interface

898: * as null since if the user has populated parent_transaction_id
899: * and parent_interface_txn_id, then we dont want to override
900: * it.
901: */
902: UPDATE rcv_transactions_interface
903: SET parent_transaction_id = l_rt_row.transaction_id
904: , shipment_line_id = l_rt_row.shipment_line_id
905: WHERE parent_interface_txn_id = l_rti_row.interface_transaction_id
906: AND parent_transaction_id IS NULL;

Line 1045: SET table_name = 'RCV_TRANSACTIONS',

1041: DECLARE
1042: l_row_id NUMBER;
1043: BEGIN
1044: UPDATE po_note_references
1045: SET table_name = 'RCV_TRANSACTIONS',
1046: column_name = 'TRANSACTION_ID',
1047: foreign_id = l_rt_row.transaction_id
1048: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'
1049: AND column_name = 'INTERFACE_TRANSACTION_ID'

Line 1048: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'

1044: UPDATE po_note_references
1045: SET table_name = 'RCV_TRANSACTIONS',
1046: column_name = 'TRANSACTION_ID',
1047: foreign_id = l_rt_row.transaction_id
1048: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'
1049: AND column_name = 'INTERFACE_TRANSACTION_ID'
1050: AND foreign_id = l_rti_row.interface_transaction_id;
1051:
1052: IF SQL%ROWCOUNT > 0 AND

Line 1123: WHERE table_name = 'RCV_TRANSACTIONS'

1119: attribute13,
1120: attribute14,
1121: attribute15
1122: FROM po_note_references
1123: WHERE table_name = 'RCV_TRANSACTIONS'
1124: AND column_name = 'TRANSACTION_ID'
1125: AND foreign_id = p_receive_id;
1126: END IF;
1127: EXCEPTION--Bug: 6487371