DBA Data[Home] [Help]

APPS.CSP_RECEIVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 418: rcv_transactions_interface_sv.convert_into_correct_qty(

414: l_rcv_transaction_rec.employee_id := l_employee_id;
415: l_rcv_transaction_rec.to_organization_id := l_organization_id;
416: l_rcv_transaction_rec.destination_subinventory := l_subinventory;
417: l_rcv_transaction_rec.primary_quantity :=
418: rcv_transactions_interface_sv.convert_into_correct_qty(
419: l_rcv_transaction_rec.transaction_quantity,
420: l_rcv_transaction_rec.transaction_uom,
421: l_rcv_transaction_rec.item_id,
422: l_rcv_transaction_rec.primary_uom);

Line 865: SELECT rcv_transactions_interface_s.NEXTVAL

861: l_rcv_transaction_rec := p_receive_rec;
862:
863: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
864: If (l_interface_transaction_id IS NULL) THEN
865: SELECT rcv_transactions_interface_s.NEXTVAL
866: INTO l_interface_transaction_id
867: FROM sys.dual;
868: END IF;
869:

Line 1100: INSERT INTO rcv_transactions_interface

1096:
1097: l_operating_unit := fnd_profile.value(name => 'DEFAULT_ORG_ID');
1098:
1099: -- populate DB items in rcv_transaction block
1100: INSERT INTO rcv_transactions_interface
1101: (
1102: interface_transaction_id
1103: , header_interface_id
1104: , GROUP_ID