APPS.RCV_INT_ORDER_PP_PVT dependencies on RCV_TRANSACTIONS

Line 1195: -- removed rcv_transactions_interface_sv.check_date_tolerance;

1191: asn_debug.put_line('cursor record ' || TO_CHAR(rows_fetched));
1192: asn_debug.put_line('int org rcv : calling get available qty');
1193: END IF;
1194:
1195: -- removed rcv_transactions_interface_sv.check_date_tolerance;
1196: -- removed check shipto_location enforcement
1197: -- removed check receipt days exception code
1198:
1199: --{

Line 1676: FROM rcv_transactions rt

1672: SELECT rt.shipment_header_id,
1673: rt.shipment_line_id
1674: INTO l_shipment_header_id,
1675: l_shipment_line_id
1676: FROM rcv_transactions rt
1677: WHERE transaction_id = x_cascaded_table(n).parent_transaction_id;
1678: END IF;
1679:
1680: SELECT rsl.requisition_line_id,

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

1793: END get_deliver_to_person_from_rsl;
1794:
1795: /* Function get_deliver_to_person_from_rt() is added as part of Bug#6375015 fix.
1796: This function is called from validate_io_rcv_line() and it tries to default
1797: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions).
1798: */
1799: FUNCTION get_deliver_to_person_from_rt(
1800: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1801: n IN BINARY_INTEGER

Line 1807: from rcv_transactions

1803: l_parent_deliver_to_person_id NUMBER := null;
1804: BEGIN
1805: select deliver_to_person_id
1806: into l_parent_deliver_to_person_id
1807: from rcv_transactions
1808: where transaction_id = x_cascaded_table(n).parent_transaction_id;
1809:
1810: IF (g_asn_debug = 'Y') THEN
1811: asn_debug.put_line('Got deliver_to_person_id of parent txn as:'||l_parent_deliver_to_person_id);

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

1820: END get_deliver_to_person_from_rt;
1821:
1822: /* Function get_deliver_to_person_from_rti() is added as part of Bug#6375015 fix.
1823: This function is called from validate_io_rcv_line() and it tries to default
1824: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions_interface).
1825: */
1826:
1827: FUNCTION get_deliver_to_person_from_rti(
1828: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 1835: from rcv_transactions_interface

1831: l_parent_deliver_to_person_id NUMBER := null;
1832: BEGIN
1833: select deliver_to_person_id
1834: into l_parent_deliver_to_person_id
1835: from rcv_transactions_interface
1836: where interface_transaction_id = x_cascaded_table(n).parent_transaction_id;
1837:
1838: IF (g_asn_debug = 'Y') THEN
1839: asn_debug.put_line('Got deliver_to_person_id of parent txn as:'||l_parent_deliver_to_person_id);