DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 341: SELECT rcv_transactions_interface_s.NEXTVAL

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:

Line 2159: SELECT rcv_transactions_interface_s.NEXTVAL

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';

Line 4484: SELECT rcv_transactions_interface_s.NEXTVAL

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';