APPS.POS_WCAPPROVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 4220: from rcv_transactions_interface

4216: /* l_interface_amount = amount which is in the interface tables /pending to be approved / rejected before the submission of
4217: current work confirmation for this payitem / distribution */
4218: select nvl(sum(amount),0)
4219: into l_interface_amount
4220: from rcv_transactions_interface
4221: where po_distribution_id= wcr_line_info.po_distribution_id
4222: and processing_status_code='PENDING'
4223: and transaction_status_code = 'PENDING'
4224: and transaction_type = 'RECEIVE';

Line 4358: from rcv_transactions_interface

4354: /* l_interface_quantity = quantity which is in the interface tables /pending to be approved / rejected before the submission of
4355: current work confirmation for this payitem / distribution */
4356: select nvl(sum(quantity),0)
4357: into l_interface_quantity
4358: from rcv_transactions_interface
4359: where po_distribution_id= wcr_line_info.po_distribution_id
4360: and processing_status_code='PENDING'
4361: and transaction_status_code = 'PENDING'
4362: and transaction_type = 'RECEIVE';

Line 4441: select rcv_transactions_interface_s.nextval

4437:
4438: /* end of code changes for bug 8810238 */
4439:
4440: If (l_insert_into_rti) then --{
4441: select rcv_transactions_interface_s.nextval
4442: into l_interface_id
4443: from dual;
4444:
4445: IF (g_asn_debug = 'Y') THEN

Line 4758: FROM RCV_TRANSACTIONS_INTERFACE RTI

4754: SELECT INTERFACE_TRANSACTION_ID,
4755: AMOUNT
4756: INTO l_int_transaction_id,
4757: l_full_fund_amt
4758: FROM RCV_TRANSACTIONS_INTERFACE RTI
4759: WHERE PO_DISTRIBUTION_ID = l_full_fund_dist_id AND
4760: GROUP_ID = l_group_id;
4761:
4762: l_full_fund_amt := l_full_fund_amt +l_remaining_amount;

Line 4765: UPDATE RCV_TRANSACTIONS_INTERFACE RTI

4761:
4762: l_full_fund_amt := l_full_fund_amt +l_remaining_amount;
4763: l_remaining_amount := 0;
4764:
4765: UPDATE RCV_TRANSACTIONS_INTERFACE RTI
4766: SET AMOUNT = l_full_fund_amt
4767: WHERE INTERFACE_TRANSACTION_ID = l_int_transaction_id AND
4768: GROUP_ID = l_group_id;
4769: END IF;

Line 4778: FROM RCV_TRANSACTIONS_INTERFACE RTI

4774: SELECT INTERFACE_TRANSACTION_ID,
4775: QUANTITY
4776: INTO l_int_transaction_id,
4777: l_full_fund_qty
4778: FROM RCV_TRANSACTIONS_INTERFACE RTI
4779: WHERE PO_DISTRIBUTION_ID = l_full_fund_dist_id AND
4780: GROUP_ID = l_group_id;
4781:
4782: l_full_fund_qty := l_full_fund_qty +l_remaining_quantity;

Line 4785: UPDATE RCV_TRANSACTIONS_INTERFACE RTI

4781:
4782: l_full_fund_qty := l_full_fund_qty +l_remaining_quantity;
4783: l_remaining_quantity := 0;
4784:
4785: UPDATE RCV_TRANSACTIONS_INTERFACE RTI
4786: SET QUANTITY = l_full_fund_qty
4787: WHERE INTERFACE_TRANSACTION_ID = l_int_transaction_id AND
4788: GROUP_ID = l_group_id;
4789: END IF;

Line 4925: UPDATE rcv_transactions_interface

4921: END IF;
4922: if (l_result_id <= 0 or l_result_id is null) then
4923:
4924:
4925: UPDATE rcv_transactions_interface
4926: set transaction_status_code = 'ERROR'
4927: where group_id = l_group_id;
4928:
4929: