238: rti.primary_quantity * -1,
239: rti.primary_quantity )
240: ),0)
241: INTO x_primary_interface_qty
242: FROM rcv_transactions_interface rti
243: WHERE rti.parent_transaction_id = x_transaction_id
244: AND rti.processing_status_code = 'PENDING'
245: AND rti.transaction_status_code = 'PENDING';
246: /*
274: ** Determine the sum of the transactions in the interface table
275: */
276: SELECT nvl(sum(rti.primary_quantity),0)
277: INTO x_primary_interface_qty
278: FROM rcv_transactions_interface rti
279: WHERE rti.parent_transaction_id = x_transaction_id
280: AND rti.processing_status_code = 'PENDING'
281: AND rti.transaction_status_code = 'PENDING';
282: /*