APPS.RCV_INT_ORDER_PP_PVT dependencies on RCV_TRANSACTIONS

Line 1146: -- removed rcv_transactions_interface_sv.check_date_tolerance;

1142: asn_debug.put_line('cursor record ' || TO_CHAR(rows_fetched));
1143: asn_debug.put_line('int org rcv : calling get available qty');
1144: END IF;
1145:
1146: -- removed rcv_transactions_interface_sv.check_date_tolerance;
1147: -- removed check shipto_location enforcement
1148: -- removed check receipt days exception code
1149:
1150: --{

Line 1617: FROM rcv_transactions rt

1613: SELECT rt.shipment_header_id,
1614: rt.shipment_line_id
1615: INTO l_shipment_header_id,
1616: l_shipment_line_id
1617: FROM rcv_transactions rt
1618: WHERE transaction_id = x_cascaded_table(n).parent_transaction_id;
1619: END IF;
1620:
1621: SELECT rsl.requisition_line_id,

Line 1734: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions).

1730: END get_deliver_to_person_from_rsl;
1731:
1732: /* Function get_deliver_to_person_from_rt() is added as part of Bug#6375015 fix.
1733: This function is called from validate_io_rcv_line() and it tries to default
1734: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions).
1735: */
1736: FUNCTION get_deliver_to_person_from_rt(
1737: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1738: n IN BINARY_INTEGER

Line 1744: from rcv_transactions

1740: l_parent_deliver_to_person_id NUMBER := null;
1741: BEGIN
1742: select deliver_to_person_id
1743: into l_parent_deliver_to_person_id
1744: from rcv_transactions
1745: where transaction_id = x_cascaded_table(n).parent_transaction_id;
1746:
1747: IF (g_asn_debug = 'Y') THEN
1748: asn_debug.put_line('Got deliver_to_person_id of parent txn as:'||l_parent_deliver_to_person_id);

Line 1761: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions_interface).

1757: END get_deliver_to_person_from_rt;
1758:
1759: /* Function get_deliver_to_person_from_rti() is added as part of Bug#6375015 fix.
1760: This function is called from validate_io_rcv_line() and it tries to default
1761: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions_interface).
1762: */
1763:
1764: FUNCTION get_deliver_to_person_from_rti(
1765: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 1772: from rcv_transactions_interface

1768: l_parent_deliver_to_person_id NUMBER := null;
1769: BEGIN
1770: select deliver_to_person_id
1771: into l_parent_deliver_to_person_id
1772: from rcv_transactions_interface
1773: where interface_transaction_id = x_cascaded_table(n).parent_transaction_id;
1774:
1775: IF (g_asn_debug = 'Y') THEN
1776: asn_debug.put_line('Got deliver_to_person_id of parent txn as:'||l_parent_deliver_to_person_id);