DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 343: SELECT rcv_transactions_interface_s.NEXTVAL

339: -- pass that to quality. So using that if it is generated.
340: IF l_rcv_transaction_rec.interface_transaction_id IS NOT NULL THEN
341: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
342: ELSE
343: SELECT rcv_transactions_interface_s.NEXTVAL
344: INTO l_interface_transaction_id
345: FROM DUAL;
346: END IF;
347:

Line 2212: SELECT rcv_transactions_interface_s.NEXTVAL

2208: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
2209: l_qa_routing_id := 2;
2210:
2211: BEGIN
2212: SELECT rcv_transactions_interface_s.NEXTVAL
2213: INTO l_rcv_transaction_rec.interface_transaction_id
2214: FROM DUAL;
2215:
2216: l_progress := '83';

Line 4751: SELECT rcv_transactions_interface_s.NEXTVAL

4747: l_rcv_rcpt_rec.inspection_required_flag := 'Y';
4748: l_rcv_rcpt_rec.routing_id := 2;
4749:
4750: BEGIN
4751: SELECT rcv_transactions_interface_s.NEXTVAL
4752: INTO l_rcv_transaction_rec.interface_transaction_id
4753: FROM DUAL;
4754:
4755: l_progress := '83';