eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on RCV_ROI_PREPROCESSOR

Line 133: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

129: - subinventory (defaulted subinv)
130: 3. Copied the remaining logic from default_to_subloc_info.
131: */
132: PROCEDURE default_for_pjm_dropship(
133: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
134: n IN BINARY_INTEGER
135: ) IS
136: l_from_subinventory rcv_transactions.from_subinventory%TYPE;
137: l_from_locator_id rcv_transactions.from_locator_id%TYPE;

Line 429: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

425:
426: -- End bug 14725305
427:
428: PROCEDURE derive_vendor_rcv_line(
429: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
430: n IN OUT NOCOPY BINARY_INTEGER,
431: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
432: x_header_record IN rcv_roi_preprocessor.header_rec_type
433: ) IS

Line 431: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

427:
428: PROCEDURE derive_vendor_rcv_line(
429: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
430: n IN OUT NOCOPY BINARY_INTEGER,
431: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
432: x_header_record IN rcv_roi_preprocessor.header_rec_type
433: ) IS
434: l_po_header_id po_headers_all.po_header_id%type;
435: l_return_status VARCHAR2(1) :='S';

Line 432: x_header_record IN rcv_roi_preprocessor.header_rec_type

428: PROCEDURE derive_vendor_rcv_line(
429: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
430: n IN OUT NOCOPY BINARY_INTEGER,
431: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
432: x_header_record IN rcv_roi_preprocessor.header_rec_type
433: ) IS
434: l_po_header_id po_headers_all.po_header_id%type;
435: l_return_status VARCHAR2(1) :='S';
436: l_complex_flag varchar2(1);

Line 613: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

609: raise;
610: END derive_vendor_rcv_line;
611:
612: PROCEDURE default_vendor_rcv_line(
613: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
614: n IN BINARY_INTEGER,
615: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
616: x_header_record IN rcv_roi_preprocessor.header_rec_type
617: ) IS

Line 616: x_header_record IN rcv_roi_preprocessor.header_rec_type

612: PROCEDURE default_vendor_rcv_line(
613: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
614: n IN BINARY_INTEGER,
615: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
616: x_header_record IN rcv_roi_preprocessor.header_rec_type
617: ) IS
618: x_progress VARCHAR2(3);
619: x_locator_control NUMBER;
620: x_default_subinventory VARCHAR2(10);

Line 1150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1146: END IF;
1147: END default_vendor_rcv_line;
1148:
1149: PROCEDURE validate_vendor_rcv_line(
1150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1151: n IN BINARY_INTEGER,
1152: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1153: x_header_record IN rcv_roi_preprocessor.header_rec_type
1154: ) IS

Line 1153: x_header_record IN rcv_roi_preprocessor.header_rec_type

1149: PROCEDURE validate_vendor_rcv_line(
1150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1151: n IN BINARY_INTEGER,
1152: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1153: x_header_record IN rcv_roi_preprocessor.header_rec_type
1154: ) IS
1155: l_parent_deliver_to_person_id NUMBER := null; --Bug#6375015
1156: l_skip_validation NUMBER := 0; --Bug#6375015
1157: BEGIN

Line 1488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1484: END IF;
1485: END validate_vendor_rcv_line;
1486:
1487: PROCEDURE validate_amt_based_rcv_line(
1488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1489: n IN BINARY_INTEGER,
1490: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1491: x_header_record IN rcv_roi_preprocessor.header_rec_type
1492: ) IS

Line 1491: x_header_record IN rcv_roi_preprocessor.header_rec_type

1487: PROCEDURE validate_amt_based_rcv_line(
1488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1489: n IN BINARY_INTEGER,
1490: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1491: x_header_record IN rcv_roi_preprocessor.header_rec_type
1492: ) IS
1493: BEGIN
1494: IF (g_asn_debug = 'Y') THEN
1495: asn_debug.put_line('Enter validate_amt_based_rcv_line');

Line 1561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1557: END IF;
1558: END validate_amt_based_rcv_line;
1559:
1560: PROCEDURE derive_ship_to_org_info(
1561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1562: n IN OUT NOCOPY BINARY_INTEGER,
1563: x_header_record IN rcv_roi_preprocessor.header_rec_type
1564: ) IS
1565: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

Line 1563: x_header_record IN rcv_roi_preprocessor.header_rec_type

1559:
1560: PROCEDURE derive_ship_to_org_info(
1561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1562: n IN OUT NOCOPY BINARY_INTEGER,
1563: x_header_record IN rcv_roi_preprocessor.header_rec_type
1564: ) IS
1565: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1566: x_to_organization_code VARCHAR2(5);
1567: BEGIN

Line 1645: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1641: END IF;
1642: END derive_ship_to_org_info;
1643:
1644: PROCEDURE derive_vendor_info(
1645: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1646: n IN OUT NOCOPY BINARY_INTEGER
1647: ) IS
1648: vendor_record rcv_shipment_header_sv.vendorrectype;
1649: BEGIN

Line 1686: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1682: END IF;
1683: END derive_vendor_info;
1684:
1685: PROCEDURE derive_vendor_site_info(
1686: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1687: n IN OUT NOCOPY BINARY_INTEGER
1688: ) IS
1689: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
1690: BEGIN

Line 1722: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1718: END IF;
1719: END derive_vendor_site_info;
1720:
1721: PROCEDURE derive_po_header_info(
1722: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1723: n IN OUT NOCOPY BINARY_INTEGER
1724: ) IS
1725: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
1726: document_num_record rcv_shipment_line_sv.document_num_record_type;

Line 1760: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1756: END IF;
1757: END derive_po_header_info;
1758:
1759: PROCEDURE derive_asn_header_info(
1760: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1761: n IN OUT NOCOPY BINARY_INTEGER,
1762: x_header_record IN rcv_roi_preprocessor.header_rec_type
1763: ) IS
1764: BEGIN

Line 1762: x_header_record IN rcv_roi_preprocessor.header_rec_type

1758:
1759: PROCEDURE derive_asn_header_info(
1760: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1761: n IN OUT NOCOPY BINARY_INTEGER,
1762: x_header_record IN rcv_roi_preprocessor.header_rec_type
1763: ) IS
1764: BEGIN
1765: IF (x_cascaded_table(n).error_status IN('S', 'W')) THEN --{
1766: /*

Line 1803: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1799: rcv_error_pkg.log_interface_error('SHIPMENT_NUM', FALSE);
1800: END derive_asn_header_info;
1801:
1802: PROCEDURE derive_item_info(
1803: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1804: n IN OUT NOCOPY BINARY_INTEGER
1805: ) IS
1806: item_id_record rcv_shipment_line_sv.item_id_record_type;
1807: BEGIN

Line 1840: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1836: END IF;
1837: END derive_item_info;
1838:
1839: PROCEDURE derive_substitute_item_info(
1840: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1841: n IN OUT NOCOPY BINARY_INTEGER
1842: ) IS
1843: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
1844: BEGIN

Line 1885: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1881: END IF;
1882: END derive_substitute_item_info;
1883:
1884: PROCEDURE derive_po_line_info(
1885: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1886: n IN OUT NOCOPY BINARY_INTEGER
1887: ) IS
1888: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
1889: release_id_record rcv_shipment_line_sv.release_id_record_type;

Line 2245: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2241: raise;
2242: END derive_po_line_info;
2243:
2244: PROCEDURE derive_from_org_info(
2245: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2246: n IN OUT NOCOPY BINARY_INTEGER
2247: ) IS
2248: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
2249: BEGIN

Line 2289: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2285: END IF;
2286: END derive_from_org_info;
2287:
2288: PROCEDURE derive_transit_org_info(
2289: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2290: n IN OUT NOCOPY BINARY_INTEGER
2291: ) IS
2292: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
2293: BEGIN

Line 2333: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2329: END IF;
2330: END derive_transit_org_info;
2331:
2332: PROCEDURE derive_location_info(
2333: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2334: n IN OUT NOCOPY BINARY_INTEGER
2335: ) IS
2336: location_id_record rcv_shipment_object_sv.location_id_record_type;
2337: BEGIN

Line 2361: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2357: END IF;
2358: END derive_location_info;
2359:
2360: PROCEDURE derive_ship_to_location_info(
2361: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2362: n IN OUT NOCOPY BINARY_INTEGER
2363: ) IS
2364: location_id_record rcv_shipment_object_sv.location_id_record_type;
2365: BEGIN

Line 2389: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2385: END IF;
2386: END derive_ship_to_location_info;
2387:
2388: PROCEDURE derive_routing_header_info(
2389: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2390: n IN OUT NOCOPY BINARY_INTEGER
2391: ) IS
2392: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
2393: BEGIN

Line 2417: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2413: END IF;
2414: END derive_routing_header_info;
2415:
2416: PROCEDURE derive_routing_step_info(
2417: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2418: n IN OUT NOCOPY BINARY_INTEGER
2419: ) IS
2420: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
2421: BEGIN

Line 2445: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2441: END IF;
2442: END derive_routing_step_info;
2443:
2444: PROCEDURE derive_deliver_to_person_info(
2445: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2446: n IN OUT NOCOPY BINARY_INTEGER
2447: ) IS
2448: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
2449: BEGIN

Line 2489: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2485: END IF;
2486: END derive_deliver_to_person_info;
2487:
2488: PROCEDURE derive_deliver_to_loc_info(
2489: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2490: n IN OUT NOCOPY BINARY_INTEGER
2491: ) IS
2492: location_id_record rcv_shipment_object_sv.location_id_record_type;
2493: BEGIN

Line 2518: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2514: END derive_deliver_to_loc_info;
2515:
2516: /* WMS Change for receiving(from) locators */
2517: PROCEDURE derive_from_locator_id(
2518: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2519: n IN OUT NOCOPY BINARY_INTEGER
2520: ) IS
2521: BEGIN
2522: IF ( x_cascaded_table(n).from_locator_id IS NULL

Line 2550: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2546: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2547: END derive_from_locator_id;
2548:
2549: PROCEDURE derive_to_locator_id(
2550: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2551: n IN OUT NOCOPY BINARY_INTEGER
2552: ) IS
2553: BEGIN
2554: IF ( x_cascaded_table(n).locator_id IS NULL

Line 2584: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2580: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2581: END derive_to_locator_id;
2582:
2583: PROCEDURE validate_non_services_fields(
2584: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2585: n IN BINARY_INTEGER
2586: ) IS
2587: BEGIN
2588: IF (g_asn_debug = 'Y') THEN

Line 2670: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2666: * Also for transfer these values are different. So it is
2667: * better to separate them out.
2668: */
2669: PROCEDURE default_from_subloc_info(
2670: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2671: n IN BINARY_INTEGER
2672: ) IS
2673: l_from_subinventory rcv_transactions.from_subinventory%TYPE;
2674: l_from_locator_id rcv_transactions.from_locator_id%TYPE;

Line 2749: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2745: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2746: END default_from_subloc_info;
2747:
2748: PROCEDURE default_to_subloc_info(
2749: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2750: n IN BINARY_INTEGER
2751: ) IS
2752: l_from_subinventory rcv_transactions.from_subinventory%TYPE;
2753: l_from_locator_id rcv_transactions.from_locator_id%TYPE;

Line 3008: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3004: END default_to_subloc_info;
3005:
3006: /* WMS Change End */
3007: PROCEDURE derive_reason_info(
3008: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3009: n IN OUT NOCOPY BINARY_INTEGER
3010: ) IS
3011: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
3012: BEGIN

Line 3036: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3032: END IF;
3033: END derive_reason_info;
3034:
3035: PROCEDURE derive_auto_transact_code(
3036: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3037: n IN OUT NOCOPY BINARY_INTEGER
3038: ) IS
3039: BEGIN
3040: IF (x_cascaded_table(n).error_status IN('S', 'W')) THEN

Line 3145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3141: END IF;
3142: END derive_auto_transact_code;
3143:
3144: PROCEDURE derive_vendor_rcv_line_qty(
3145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3146: n IN OUT NOCOPY BINARY_INTEGER,
3147: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3148: x_header_record IN rcv_roi_preprocessor.header_rec_type
3149: ) IS

Line 3147: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3143:
3144: PROCEDURE derive_vendor_rcv_line_qty(
3145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3146: n IN OUT NOCOPY BINARY_INTEGER,
3147: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3148: x_header_record IN rcv_roi_preprocessor.header_rec_type
3149: ) IS
3150: x_include_closed_po VARCHAR2(1); -- Bug 1887728
3151:

Line 3148: x_header_record IN rcv_roi_preprocessor.header_rec_type

3144: PROCEDURE derive_vendor_rcv_line_qty(
3145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3146: n IN OUT NOCOPY BINARY_INTEGER,
3147: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3148: x_header_record IN rcv_roi_preprocessor.header_rec_type
3149: ) IS
3150: x_include_closed_po VARCHAR2(1); -- Bug 1887728
3151:
3152: /* R12 Complex Work.

Line 5874: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

5870: END IF;
5871: END derive_vendor_rcv_line_qty;
5872:
5873: PROCEDURE derive_vendor_rcv_line_amt(
5874: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5875: n IN OUT NOCOPY BINARY_INTEGER,
5876: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5877: x_header_record IN rcv_roi_preprocessor.header_rec_type
5878: ) IS

Line 5876: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

5872:
5873: PROCEDURE derive_vendor_rcv_line_amt(
5874: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5875: n IN OUT NOCOPY BINARY_INTEGER,
5876: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5877: x_header_record IN rcv_roi_preprocessor.header_rec_type
5878: ) IS
5879: x_include_closed_po VARCHAR2(1); -- Bug 1887728
5880:

Line 5877: x_header_record IN rcv_roi_preprocessor.header_rec_type

5873: PROCEDURE derive_vendor_rcv_line_amt(
5874: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5875: n IN OUT NOCOPY BINARY_INTEGER,
5876: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5877: x_header_record IN rcv_roi_preprocessor.header_rec_type
5878: ) IS
5879: x_include_closed_po VARCHAR2(1); -- Bug 1887728
5880:
5881: CURSOR shipments(

Line 7380: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7376: END IF;
7377: END derive_vendor_rcv_line_amt;
7378:
7379: PROCEDURE validate_transaction_date(
7380: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7381: n IN BINARY_INTEGER
7382: ) IS
7383: x_val_open_ok BOOLEAN := NULL;
7384: x_sob_id NUMBER := NULL;

Line 7535: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7531: );
7532: END validate_transaction_date;
7533:
7534: PROCEDURE validate_quantity_invoiced(
7535: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7536: n IN BINARY_INTEGER
7537: ) IS
7538: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
7539: BEGIN

Line 7557: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7553: );
7554: END validate_quantity_invoiced;
7555:
7556: PROCEDURE validate_transaction_uom(
7557: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7558: n IN BINARY_INTEGER
7559: ) IS
7560: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
7561: BEGIN

Line 7596: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7592: );
7593: END validate_transaction_uom;
7594:
7595: PROCEDURE validate_item_info(
7596: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7597: n IN BINARY_INTEGER
7598: ) IS
7599: item_revision_record rcv_shipment_line_sv.item_id_record_type;
7600: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

Line 7693: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7689: NULL;
7690: END validate_item_info;
7691:
7692: PROCEDURE validate_freight_carrier_code(
7693: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7694: n IN BINARY_INTEGER
7695: ) IS
7696: X_rsh_freight_carrier_code rcv_shipment_headers.freight_carrier_code%TYPE := '-999999'; /* Bug 8722496 */
7697: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

Line 7753: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7749: END IF; --}
7750: END validate_freight_carrier_code;
7751:
7752: PROCEDURE validate_dest_type(
7753: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7754: n IN BINARY_INTEGER
7755: ) IS
7756: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
7757: BEGIN

Line 7784: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7780: );
7781: END validate_dest_type;
7782:
7783: PROCEDURE validate_ship_to_loc(
7784: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7785: n IN BINARY_INTEGER
7786: ) IS
7787: location_record rcv_shipment_line_sv.location_record_type;
7788: BEGIN

Line 7833: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7829: );
7830: END validate_ship_to_loc;
7831:
7832: PROCEDURE validate_deliver_to_person(
7833: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7834: n IN BINARY_INTEGER
7835: ) IS
7836: employee_record rcv_shipment_line_sv.employee_record_type;
7837: BEGIN

Line 7890: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7886: */
7887: END validate_deliver_to_person;
7888:
7889: PROCEDURE validate_routing_record(
7890: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7891: n IN BINARY_INTEGER
7892: ) IS
7893: x_error_status VARCHAR2(1);
7894:

Line 7992: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7988: );
7989: END validate_routing_record;
7990:
7991: PROCEDURE validate_deliver_to_loc(
7992: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7993: n IN BINARY_INTEGER
7994: ) IS
7995: location_record rcv_shipment_line_sv.location_record_type;
7996: BEGIN

Line 8031: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8027: END validate_deliver_to_loc;
8028:
8029: /* WMS Changes */
8030: PROCEDURE validate_subinventory(
8031: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8032: n IN BINARY_INTEGER
8033: ) IS
8034: x_subinventory VARCHAR2(10) := NULL;
8035: l_api_version CONSTANT NUMBER := 1.0;

Line 8213: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8209: rcv_error_pkg.log_interface_error('SUBINVENTORY', FALSE);
8210: END validate_subinventory;
8211:
8212: PROCEDURE validate_locator(
8213: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8214: n IN BINARY_INTEGER
8215: ) IS
8216: locator_record rcv_shipment_line_sv.locator_record_type;
8217: l_transaction_type_id NUMBER;

Line 8356: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8352: END IF;
8353: END validate_locator;
8354:
8355: PROCEDURE validate_tax_code(
8356: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8357: n IN BINARY_INTEGER,
8358: /* Bug3454491 (4) */
8359: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8360: ) IS

Line 8389: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8385: END IF;
8386: END validate_tax_code;
8387:
8388: PROCEDURE validate_country_of_origin(
8389: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8390: n IN BINARY_INTEGER
8391: ) IS
8392: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
8393: BEGIN

Line 8419: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8415: END IF;
8416: END validate_country_of_origin;
8417:
8418: PROCEDURE validate_asl(
8419: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8420: n IN BINARY_INTEGER
8421: ) IS
8422: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
8423: BEGIN

Line 8450: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8446: );
8447: END validate_asl;
8448:
8449: PROCEDURE validate_shipped_qty(
8450: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8451: n IN BINARY_INTEGER
8452: ) IS
8453: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
8454: BEGIN

Line 8488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8484: END IF; -- vendor_cum_shipped_qty <> 0
8485: END validate_shipped_qty;
8486:
8487: PROCEDURE validate_ref_integrity(
8488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8489: n IN BINARY_INTEGER,
8490: x_header_record IN rcv_roi_preprocessor.header_rec_type
8491: ) IS
8492: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;

Line 8490: x_header_record IN rcv_roi_preprocessor.header_rec_type

8486:
8487: PROCEDURE validate_ref_integrity(
8488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8489: n IN BINARY_INTEGER,
8490: x_header_record IN rcv_roi_preprocessor.header_rec_type
8491: ) IS
8492: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
8493: l_job_id po_lines.job_id%TYPE;
8494: l_item_description po_lines.item_description%TYPE;

Line 8708: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8704: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
8705: END validate_ref_integrity;
8706:
8707: PROCEDURE exchange_sub_items(
8708: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8709: n IN BINARY_INTEGER
8710: ) IS
8711: location_record rcv_shipment_line_sv.location_record_type;
8712: x_item_id NUMBER;

Line 8825: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8821: END IF;
8822: END exchange_sub_items;
8823:
8824: PROCEDURE validate_consigned_inventory(
8825: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8826: n IN BINARY_INTEGER,
8827: /* Bug3454491 (5) */
8828: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8829: ) IS

Line 8934: x_header_record IN rcv_roi_preprocessor.header_rec_type

8930: END validate_consigned_inventory;
8931:
8932: PROCEDURE validate_ref_integ(
8933: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
8934: x_header_record IN rcv_roi_preprocessor.header_rec_type
8935: ) IS
8936: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
8937: x_po_line_id po_lines.po_line_id%TYPE;
8938: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;

Line 9064: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9060: END IF;
9061: END validate_ref_integ;
9062:
9063: PROCEDURE validate_temp_labor_info(
9064: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9065: n IN BINARY_INTEGER,
9066: v_header_record IN rcv_roi_preprocessor.header_rec_type
9067: ) IS
9068: x_error_status VARCHAR2(1);

Line 9066: v_header_record IN rcv_roi_preprocessor.header_rec_type

9062:
9063: PROCEDURE validate_temp_labor_info(
9064: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9065: n IN BINARY_INTEGER,
9066: v_header_record IN rcv_roi_preprocessor.header_rec_type
9067: ) IS
9068: x_error_status VARCHAR2(1);
9069: BEGIN
9070: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 9096: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9092: END IF;
9093: END validate_temp_labor_info;
9094:
9095: PROCEDURE validate_amount(
9096: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9097: n IN BINARY_INTEGER,
9098: v_header_record IN rcv_roi_preprocessor.header_rec_type
9099: ) IS
9100: x_error_status VARCHAR2(1);

Line 9098: v_header_record IN rcv_roi_preprocessor.header_rec_type

9094:
9095: PROCEDURE validate_amount(
9096: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9097: n IN BINARY_INTEGER,
9098: v_header_record IN rcv_roi_preprocessor.header_rec_type
9099: ) IS
9100: x_error_status VARCHAR2(1);
9101: BEGIN
9102: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 9126: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9122: END IF;
9123: END validate_amount;
9124:
9125: PROCEDURE handle_rcv_asn_transactions(
9126: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9127: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
9128: ) IS
9129: v_current_interface_id NUMBER;
9130: v_prior_interface_id NUMBER;

Line 9127: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

9123: END validate_amount;
9124:
9125: PROCEDURE handle_rcv_asn_transactions(
9126: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9127: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
9128: ) IS
9129: v_current_interface_id NUMBER;
9130: v_prior_interface_id NUMBER;
9131: i BINARY_INTEGER := 0;

Line 10026: rcv_roi_preprocessor.update_rti_error

10022: WHERE interface_transaction_id = l_ls_table(k).new_interface_trx_id;
10023:
10024: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_all_lines);
10025: IF ( x_fail_all_lines='Y') THEN
10026: rcv_roi_preprocessor.update_rti_error
10027: (null,
10028: null,
10029: l_header_interface_id,
10030: null);

Line 10092: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

10088: END IF;
10089: END handle_rcv_asn_transactions;
10090:
10091: PROCEDURE derive_vendor_trans_del(
10092: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10093: n IN OUT NOCOPY BINARY_INTEGER,
10094: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10095: x_header_record IN rcv_roi_preprocessor.header_rec_type
10096: ) IS

Line 10094: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

10090:
10091: PROCEDURE derive_vendor_trans_del(
10092: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10093: n IN OUT NOCOPY BINARY_INTEGER,
10094: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10095: x_header_record IN rcv_roi_preprocessor.header_rec_type
10096: ) IS
10097: test NUMBER;
10098: BEGIN

Line 10095: x_header_record IN rcv_roi_preprocessor.header_rec_type

10091: PROCEDURE derive_vendor_trans_del(
10092: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10093: n IN OUT NOCOPY BINARY_INTEGER,
10094: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10095: x_header_record IN rcv_roi_preprocessor.header_rec_type
10096: ) IS
10097: test NUMBER;
10098: BEGIN
10099: IF (g_asn_debug = 'Y') THEN

Line 10148: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

10144: );
10145: END derive_vendor_trans_del;
10146:
10147: PROCEDURE derive_parent_id(
10148: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10149: n IN OUT NOCOPY BINARY_INTEGER
10150: ) IS
10151: derive_values_from_plsql_table BOOLEAN := FALSE;
10152: cascaded_table_index NUMBER;

Line 10342: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

10338: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
10339: END derive_parent_id;
10340:
10341: PROCEDURE derive_trans_del_line_quantity(
10342: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10343: n IN OUT NOCOPY BINARY_INTEGER,
10344: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
10345: ) IS
10346: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 10344: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

10340:
10341: PROCEDURE derive_trans_del_line_quantity(
10342: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10343: n IN OUT NOCOPY BINARY_INTEGER,
10344: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
10345: ) IS
10346: x_include_closed_po VARCHAR2(1); -- Bug 1887728
10347: /*
10348: ** Might be a compatibility issue between the two record definitions

Line 12749: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

12745: * but since the code is the same for RMAs, the cursor has been expanded
12746: * to include RMA information as well and the procedure reused for RMAs.
12747: */
12748: PROCEDURE default_vendor_trans_del(
12749: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
12750: n IN BINARY_INTEGER
12751: ) IS
12752: p_trx_record rcv_roi_header_common.common_default_record_type;
12753:

Line 13132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

13128: END default_vendor_trans_del;
13129:
13130:
13131: PROCEDURE derive_correction_line(
13132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13133: n IN OUT NOCOPY BINARY_INTEGER,
13134: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13135: x_header_record IN rcv_roi_preprocessor.header_rec_type
13136: ) IS

Line 13134: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

13130:
13131: PROCEDURE derive_correction_line(
13132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13133: n IN OUT NOCOPY BINARY_INTEGER,
13134: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13135: x_header_record IN rcv_roi_preprocessor.header_rec_type
13136: ) IS
13137: l_po_header_id po_headers_all.po_header_id%type;
13138: l_return_status VARCHAR2(1) :='S';

Line 13135: x_header_record IN rcv_roi_preprocessor.header_rec_type

13131: PROCEDURE derive_correction_line(
13132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13133: n IN OUT NOCOPY BINARY_INTEGER,
13134: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13135: x_header_record IN rcv_roi_preprocessor.header_rec_type
13136: ) IS
13137: l_po_header_id po_headers_all.po_header_id%type;
13138: l_return_status VARCHAR2(1) :='S';
13139: l_complex_flag varchar2(1);

Line 13300: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

13296: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
13297: END derive_correction_line;
13298:
13299: PROCEDURE derive_correction_line_qty(
13300: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13301: n IN OUT NOCOPY BINARY_INTEGER,
13302: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
13303: ) IS
13304: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 13302: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

13298:
13299: PROCEDURE derive_correction_line_qty(
13300: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13301: n IN OUT NOCOPY BINARY_INTEGER,
13302: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
13303: ) IS
13304: x_include_closed_po VARCHAR2(1); -- Bug 1887728
13305: /*
13306: ** Might be a compatibility issue between the two record definitions

Line 14504: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14500: END IF;
14501: END derive_correction_line_qty;
14502:
14503: PROCEDURE derive_correction_line_amt(
14504: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14505: n IN OUT NOCOPY BINARY_INTEGER,
14506: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
14507: ) IS
14508: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 14506: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

14502:
14503: PROCEDURE derive_correction_line_amt(
14504: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14505: n IN OUT NOCOPY BINARY_INTEGER,
14506: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
14507: ) IS
14508: x_include_closed_po VARCHAR2(1); -- Bug 1887728
14509: /*
14510: ** Might be a compatibility issue between the two record definitions

Line 15557: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15553: END IF;
15554: END derive_correction_line_amt;
15555:
15556: PROCEDURE default_vendor_correct(
15557: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15558: n IN BINARY_INTEGER
15559: ) IS
15560: p_trx_record rcv_roi_header_common.common_default_record_type;
15561:

Line 15967: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15963: RETURN(correct_qty);
15964: END;
15965:
15966: PROCEDURE validate_source_type(
15967: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15968: n IN BINARY_INTEGER
15969: ) IS
15970: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
15971: BEGIN

Line 16016: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16012: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
16013: END validate_source_type;
16014:
16015: PROCEDURE validate_transaction_type(
16016: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16017: n IN BINARY_INTEGER
16018: ) IS
16019: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
16020: BEGIN

Line 16052: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16048: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
16049: END validate_transaction_type;
16050:
16051: PROCEDURE validate_inspection_status(
16052: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16053: n IN BINARY_INTEGER
16054: ) IS
16055: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
16056: BEGIN

Line 16091: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16087: /** OPM change Bug# 3061052**/
16088: -- added validate_opm_attributes to validate OPM specific columns.
16089:
16090: PROCEDURE validate_opm_attributes(
16091: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16092: n IN BINARY_INTEGER
16093: ) IS
16094: /*INVCONV, gml_opm_roi_grp.opm_record_type to be removed , Punit Kumar */
16095: --l_opm_record_type gml_opm_roi_grp.opm_record_type;

Line 16369: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16365: END validate_opm_attributes;
16366:
16367:
16368: PROCEDURE get_interface_available_qty(
16369: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16370: n IN BINARY_INTEGER,
16371: x_interface_qty OUT NOCOPY NUMBER
16372: ) IS
16373: l_grandparent_interface_trx_id NUMBER;

Line 16453: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16449: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
16450: END get_interface_available_qty;
16451:
16452: PROCEDURE get_interface_available_amt(
16453: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16454: n IN BINARY_INTEGER,
16455: x_interface_amt OUT NOCOPY NUMBER
16456: ) IS
16457: l_grandparent_interface_trx_id NUMBER;

Line 16523: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16519: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
16520: END get_interface_available_amt;
16521:
16522: PROCEDURE update_interface_available_qty(
16523: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16524: n IN BINARY_INTEGER
16525: ) IS
16526: l_grandparent_interface_trx_id NUMBER;
16527: l_parent_trx_type rcv_transactions_interface.transaction_type%TYPE;

Line 16606: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16602: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
16603: END update_interface_available_qty;
16604:
16605: PROCEDURE update_interface_available_amt(
16606: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16607: n IN BINARY_INTEGER
16608: ) IS
16609: l_grandparent_interface_trx_id NUMBER;
16610: l_parent_trx_type rcv_transactions_interface.transaction_type%TYPE;

Line 16832: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

16828: RAISE;
16829: END update_total_transaction_amt;
16830:
16831: PROCEDURE derive_matching_basis(
16832: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
16833: n IN BINARY_INTEGER
16834: ) IS
16835: x_progress varchar2(3);
16836: begin

Line 17029: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17025: Purchase order. If po_distribution_id is not known, it will try to get the
17026: value based on po_line_location only if the poll has got single distribution.
17027: */
17028: PROCEDURE get_deliver_to_person_from_po(
17029: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17030: n IN BINARY_INTEGER
17031: ) IS
17032: l_deliver_to_person_id NUMBER;
17033: l_distribution_count NUMBER;

Line 17104: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17100: This function is called from validate_vendor_rcv_line() and it tries to default
17101: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions).
17102: */
17103: FUNCTION get_deliver_to_person_from_rt(
17104: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17105: n IN BINARY_INTEGER
17106: ) RETURN NUMBER IS
17107: l_parent_deliver_to_person_id NUMBER := null;
17108: BEGIN

Line 17132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17128: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions_interface).
17129: */
17130:
17131: FUNCTION get_deliver_to_person_from_rti(
17132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17133: n IN BINARY_INTEGER
17134: ) RETURN NUMBER IS
17135: l_parent_deliver_to_person_id NUMBER := null;
17136: BEGIN

Line 17155: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17151: return null;
17152: END get_deliver_to_person_from_rti;
17153:
17154: PROCEDURE validate_lcm_line
17155: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17156: n IN binary_integer,
17157: x_asn_type IN rcv_headers_interface.asn_type%type,
17158: x_header_record IN rcv_roi_preprocessor.header_rec_type
17159: ) IS

Line 17158: x_header_record IN rcv_roi_preprocessor.header_rec_type

17154: PROCEDURE validate_lcm_line
17155: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17156: n IN binary_integer,
17157: x_asn_type IN rcv_headers_interface.asn_type%type,
17158: x_header_record IN rcv_roi_preprocessor.header_rec_type
17159: ) IS
17160:
17161: l_pre_rcv_flag VARCHAR2(1);
17162: l_lcm_shipment_flag VARCHAR2(1);

Line 17485: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17481: END validate_lcm_line;
17482:
17483: -- Bug 7651646
17484: PROCEDURE validate_src_txn(
17485: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17486: n IN BINARY_INTEGER
17487: ) IS
17488: l_count NUMBER := 0;
17489: BEGIN

Line 17527: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17523: END validate_src_txn;
17524:
17525: --
17526: PROCEDURE get_clm_info(p_validate_type VARCHAR2,
17527: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17528: n IN BINARY_INTEGER,
17529: x_is_clm_po IN OUT NOCOPY VARCHAR2,
17530: x_partial_funded_flag IN OUT NOCOPY VARCHAR2) IS
17531:

Line 17642: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17638: --
17639:
17640: -- Bug#9705269 :Start
17641: PROCEDURE validate_shipment_source(
17642: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17643: n IN BINARY_INTEGER
17644: ) IS
17645: l_mmt_transaction_id rcv_shipment_lines.mmt_transaction_id%type;
17646: l_record_exists number := 0;

Line 17690: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

17686: -- Bug#9705269 :End
17687:
17688: -- rtv project : start
17689: PROCEDURE validate_parent_rtv
17690: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17691: n IN BINARY_INTEGER) IS
17692:
17693: l_count number := 0;
17694: BEGIN