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.

[Home] [Help]

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 186: SELECT rcv_transactions_s.NEXTVAL

182: || ', p_correct_id: ' || p_correct_id
183: || ', p_return_id: ' || p_return_id
184: || ')');
185:
186: SELECT rcv_transactions_s.NEXTVAL
187: INTO l_rt_row.transaction_id
188: FROM DUAL;
189:
190: -- Bug 4401341

Line 195: use them to populate rcv_transactions table.

191: /*Commenting the rcv_table_functions.get_rti_frow_from_id call and fetching
192: the value from rti table as lpn_id fetched from the cache table does not
193: have the value that is updated by Inventory.There may be other fields that
194: would have got updated.So fetching all the values directly from rti and then
195: use them to populate rcv_transactions table.
196: */
197: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
198:
199: select *

Line 201: from rcv_transactions_interface

197: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
198:
199: select *
200: into l_rti_row
201: from rcv_transactions_interface
202: where interface_transaction_id = p_rti_id;
203:
204: -- default values
205: l_rt_row.user_entered_flag := 'Y';

Line 466: --rcv_transactions table.

462: END IF;
463: ELSE
464: --Bug 4401341 : If transaction_type is 'SHIP' and auto_transact_code is
465: --'RECEIVE', then we stamp the lpn_id and transfer_lpn_id columns in
466: --rcv_transactions table.
467: IF p_transaction_type = 'DELIVER' AND
468: l_rti_row.transaction_type = 'RECEIVE'
469: THEN
470: l_rt_row.lpn_id := l_rti_row.transfer_lpn_id;

Line 557: INSERT INTO RCV_TRANSACTIONS

553: );
554:
555: /* GSCC errors come up when we use the foll. insert.
556: * Changing to use the full insert stmts.
557: INSERT INTO RCV_TRANSACTIONS
558: VALUES l_rt_row;
559: */
560: /* Bug: 6487371
561: * Added exception handler to catch the exception when insertion into rcv_transactions

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

557: INSERT INTO RCV_TRANSACTIONS
558: VALUES l_rt_row;
559: */
560: /* Bug: 6487371
561: * Added exception handler to catch the exception when insertion into rcv_transactions
562: * fails due to exception raised in the triggers(for eg; India Localisation triggers) on
563: * rcv_transactions table. Similarly added exception handler for insertion into
564: * po_note_references table. To this rvthinns() function as whole, added one exception handler.
565: * While storing sqlerrm in the x_message_data getting only the first 200 bytes.

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

559: */
560: /* Bug: 6487371
561: * Added exception handler to catch the exception when insertion into rcv_transactions
562: * fails due to exception raised in the triggers(for eg; India Localisation triggers) on
563: * rcv_transactions table. Similarly added exception handler for insertion into
564: * po_note_references table. To this rvthinns() function as whole, added one exception handler.
565: * While storing sqlerrm in the x_message_data getting only the first 200 bytes.
566: * without that unhandled exception is raised while copying the sqlerrm. And moreover
567: * in rvtth.lpc rvthinns(), x_msg_data is defined to store only 200 bytes.

Line 570: INSERT INTO rcv_transactions

566: * without that unhandled exception is raised while copying the sqlerrm. And moreover
567: * in rvtth.lpc rvthinns(), x_msg_data is defined to store only 200 bytes.
568: */
569: BEGIN --Bug: 6487371
570: INSERT INTO rcv_transactions
571: (transaction_id,
572: last_update_date,
573: last_updated_by,
574: created_by,

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

802: l_rt_row.lcm_shipment_line_id, -- lcm changes
803: l_rt_row.unit_landed_cost); -- lcm changes
804: EXCEPTION --Bug: 6487371
805: when others then
806: asn_debug.put_line('Error occured while inserting into rcv_transactions...'||sqlerrm);
807: x_error_message := substr(sqlerrm,1,200);
808: RETURN;
809: END;--Bug: 6487371
810:

Line 826: UPDATE rcv_transactions_interface

822: * as null since if the user has populated parent_transaction_id
823: * and parent_interface_txn_id, then we dont want to override
824: * it.
825: */
826: UPDATE rcv_transactions_interface
827: SET parent_transaction_id = l_rt_row.transaction_id
828: , shipment_line_id = l_rt_row.shipment_line_id
829: WHERE parent_interface_txn_id = l_rti_row.interface_transaction_id
830: AND parent_transaction_id IS NULL;

Line 969: SET table_name = 'RCV_TRANSACTIONS',

965: DECLARE
966: l_row_id NUMBER;
967: BEGIN
968: UPDATE po_note_references
969: SET table_name = 'RCV_TRANSACTIONS',
970: column_name = 'TRANSACTION_ID',
971: foreign_id = l_rt_row.transaction_id
972: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'
973: AND column_name = 'INTERFACE_TRANSACTION_ID'

Line 972: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'

968: UPDATE po_note_references
969: SET table_name = 'RCV_TRANSACTIONS',
970: column_name = 'TRANSACTION_ID',
971: foreign_id = l_rt_row.transaction_id
972: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'
973: AND column_name = 'INTERFACE_TRANSACTION_ID'
974: AND foreign_id = l_rti_row.interface_transaction_id;
975:
976: IF SQL%ROWCOUNT > 0 AND

Line 1047: WHERE table_name = 'RCV_TRANSACTIONS'

1043: attribute13,
1044: attribute14,
1045: attribute15
1046: FROM po_note_references
1047: WHERE table_name = 'RCV_TRANSACTIONS'
1048: AND column_name = 'TRANSACTION_ID'
1049: AND foreign_id = p_receive_id;
1050: END IF;
1051: EXCEPTION--Bug: 6487371