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 12: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8: x_auto_deliver VARCHAR2(1);
9: e_validation_error EXCEPTION;
10:
11: PROCEDURE derive_vendor_rcv_line(
12: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13: n IN OUT NOCOPY BINARY_INTEGER,
14: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15: x_header_record IN rcv_roi_preprocessor.header_rec_type
16: ) IS

Line 14: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

10:
11: PROCEDURE derive_vendor_rcv_line(
12: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13: n IN OUT NOCOPY BINARY_INTEGER,
14: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15: x_header_record IN rcv_roi_preprocessor.header_rec_type
16: ) IS
17: l_po_header_id po_headers_all.po_header_id%type;
18: l_return_status VARCHAR2(1) :='S';

Line 15: x_header_record IN rcv_roi_preprocessor.header_rec_type

11: PROCEDURE derive_vendor_rcv_line(
12: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13: n IN OUT NOCOPY BINARY_INTEGER,
14: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15: x_header_record IN rcv_roi_preprocessor.header_rec_type
16: ) IS
17: l_po_header_id po_headers_all.po_header_id%type;
18: l_return_status VARCHAR2(1) :='S';
19: l_complex_flag varchar2(1);

Line 196: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

192: raise;
193: END derive_vendor_rcv_line;
194:
195: PROCEDURE default_vendor_rcv_line(
196: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
197: n IN BINARY_INTEGER,
198: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
199: x_header_record IN rcv_roi_preprocessor.header_rec_type
200: ) IS

Line 199: x_header_record IN rcv_roi_preprocessor.header_rec_type

195: PROCEDURE default_vendor_rcv_line(
196: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
197: n IN BINARY_INTEGER,
198: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
199: x_header_record IN rcv_roi_preprocessor.header_rec_type
200: ) IS
201: x_progress VARCHAR2(3);
202: x_locator_control NUMBER;
203: x_default_subinventory VARCHAR2(10);

Line 726: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

722: END IF;
723: END default_vendor_rcv_line;
724:
725: PROCEDURE validate_vendor_rcv_line(
726: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
727: n IN BINARY_INTEGER,
728: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
729: x_header_record IN rcv_roi_preprocessor.header_rec_type
730: ) IS

Line 729: x_header_record IN rcv_roi_preprocessor.header_rec_type

725: PROCEDURE validate_vendor_rcv_line(
726: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
727: n IN BINARY_INTEGER,
728: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
729: x_header_record IN rcv_roi_preprocessor.header_rec_type
730: ) IS
731: l_parent_deliver_to_person_id NUMBER := null; --Bug#6375015
732: l_skip_validation NUMBER := 0; --Bug#6375015
733: BEGIN

Line 1061: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1057: END IF;
1058: END validate_vendor_rcv_line;
1059:
1060: PROCEDURE validate_amt_based_rcv_line(
1061: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1062: n IN BINARY_INTEGER,
1063: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1064: x_header_record IN rcv_roi_preprocessor.header_rec_type
1065: ) IS

Line 1064: x_header_record IN rcv_roi_preprocessor.header_rec_type

1060: PROCEDURE validate_amt_based_rcv_line(
1061: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1062: n IN BINARY_INTEGER,
1063: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1064: x_header_record IN rcv_roi_preprocessor.header_rec_type
1065: ) IS
1066: BEGIN
1067: IF (g_asn_debug = 'Y') THEN
1068: asn_debug.put_line('Enter validate_amt_based_rcv_line');

Line 1134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1130: END IF;
1131: END validate_amt_based_rcv_line;
1132:
1133: PROCEDURE derive_ship_to_org_info(
1134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1135: n IN OUT NOCOPY BINARY_INTEGER,
1136: x_header_record IN rcv_roi_preprocessor.header_rec_type
1137: ) IS
1138: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

Line 1136: x_header_record IN rcv_roi_preprocessor.header_rec_type

1132:
1133: PROCEDURE derive_ship_to_org_info(
1134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1135: n IN OUT NOCOPY BINARY_INTEGER,
1136: x_header_record IN rcv_roi_preprocessor.header_rec_type
1137: ) IS
1138: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1139: x_to_organization_code VARCHAR2(5);
1140: BEGIN

Line 1218: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1214: END IF;
1215: END derive_ship_to_org_info;
1216:
1217: PROCEDURE derive_vendor_info(
1218: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1219: n IN OUT NOCOPY BINARY_INTEGER
1220: ) IS
1221: vendor_record rcv_shipment_header_sv.vendorrectype;
1222: BEGIN

Line 1259: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1255: END IF;
1256: END derive_vendor_info;
1257:
1258: PROCEDURE derive_vendor_site_info(
1259: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1260: n IN OUT NOCOPY BINARY_INTEGER
1261: ) IS
1262: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
1263: BEGIN

Line 1295: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1291: END IF;
1292: END derive_vendor_site_info;
1293:
1294: PROCEDURE derive_po_header_info(
1295: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1296: n IN OUT NOCOPY BINARY_INTEGER
1297: ) IS
1298: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
1299: document_num_record rcv_shipment_line_sv.document_num_record_type;

Line 1333: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1329: END IF;
1330: END derive_po_header_info;
1331:
1332: PROCEDURE derive_asn_header_info(
1333: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1334: n IN OUT NOCOPY BINARY_INTEGER,
1335: x_header_record IN rcv_roi_preprocessor.header_rec_type
1336: ) IS
1337: BEGIN

Line 1335: x_header_record IN rcv_roi_preprocessor.header_rec_type

1331:
1332: PROCEDURE derive_asn_header_info(
1333: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1334: n IN OUT NOCOPY BINARY_INTEGER,
1335: x_header_record IN rcv_roi_preprocessor.header_rec_type
1336: ) IS
1337: BEGIN
1338: IF (x_cascaded_table(n).error_status IN('S', 'W')) THEN --{
1339: /*

Line 1376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1372: rcv_error_pkg.log_interface_error('SHIPMENT_NUM', FALSE);
1373: END derive_asn_header_info;
1374:
1375: PROCEDURE derive_item_info(
1376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1377: n IN OUT NOCOPY BINARY_INTEGER
1378: ) IS
1379: item_id_record rcv_shipment_line_sv.item_id_record_type;
1380: BEGIN

Line 1413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1409: END IF;
1410: END derive_item_info;
1411:
1412: PROCEDURE derive_substitute_item_info(
1413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1414: n IN OUT NOCOPY BINARY_INTEGER
1415: ) IS
1416: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
1417: BEGIN

Line 1458: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1454: END IF;
1455: END derive_substitute_item_info;
1456:
1457: PROCEDURE derive_po_line_info(
1458: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1459: n IN OUT NOCOPY BINARY_INTEGER
1460: ) IS
1461: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
1462: release_id_record rcv_shipment_line_sv.release_id_record_type;

Line 1763: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1759: raise;
1760: END derive_po_line_info;
1761:
1762: PROCEDURE derive_from_org_info(
1763: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1764: n IN OUT NOCOPY BINARY_INTEGER
1765: ) IS
1766: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1767: BEGIN

Line 1807: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1803: END IF;
1804: END derive_from_org_info;
1805:
1806: PROCEDURE derive_transit_org_info(
1807: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1808: n IN OUT NOCOPY BINARY_INTEGER
1809: ) IS
1810: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1811: BEGIN

Line 1851: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1847: END IF;
1848: END derive_transit_org_info;
1849:
1850: PROCEDURE derive_location_info(
1851: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1852: n IN OUT NOCOPY BINARY_INTEGER
1853: ) IS
1854: location_id_record rcv_shipment_object_sv.location_id_record_type;
1855: BEGIN

Line 1879: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1875: END IF;
1876: END derive_location_info;
1877:
1878: PROCEDURE derive_ship_to_location_info(
1879: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1880: n IN OUT NOCOPY BINARY_INTEGER
1881: ) IS
1882: location_id_record rcv_shipment_object_sv.location_id_record_type;
1883: BEGIN

Line 1907: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1903: END IF;
1904: END derive_ship_to_location_info;
1905:
1906: PROCEDURE derive_routing_header_info(
1907: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1908: n IN OUT NOCOPY BINARY_INTEGER
1909: ) IS
1910: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
1911: BEGIN

Line 1935: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1931: END IF;
1932: END derive_routing_header_info;
1933:
1934: PROCEDURE derive_routing_step_info(
1935: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1936: n IN OUT NOCOPY BINARY_INTEGER
1937: ) IS
1938: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
1939: BEGIN

Line 1963: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1959: END IF;
1960: END derive_routing_step_info;
1961:
1962: PROCEDURE derive_deliver_to_person_info(
1963: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1964: n IN OUT NOCOPY BINARY_INTEGER
1965: ) IS
1966: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
1967: BEGIN

Line 2007: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2003: END IF;
2004: END derive_deliver_to_person_info;
2005:
2006: PROCEDURE derive_deliver_to_loc_info(
2007: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2008: n IN OUT NOCOPY BINARY_INTEGER
2009: ) IS
2010: location_id_record rcv_shipment_object_sv.location_id_record_type;
2011: BEGIN

Line 2036: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2032: END derive_deliver_to_loc_info;
2033:
2034: /* WMS Change for receiving(from) locators */
2035: PROCEDURE derive_from_locator_id(
2036: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2037: n IN OUT NOCOPY BINARY_INTEGER
2038: ) IS
2039: BEGIN
2040: IF ( x_cascaded_table(n).from_locator_id IS NULL

Line 2068: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2064: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2065: END derive_from_locator_id;
2066:
2067: PROCEDURE derive_to_locator_id(
2068: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2069: n IN OUT NOCOPY BINARY_INTEGER
2070: ) IS
2071: BEGIN
2072: IF ( x_cascaded_table(n).locator_id IS NULL

Line 2102: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2098: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2099: END derive_to_locator_id;
2100:
2101: PROCEDURE validate_non_services_fields(
2102: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2103: n IN BINARY_INTEGER
2104: ) IS
2105: BEGIN
2106: IF (g_asn_debug = 'Y') THEN

Line 2188: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2184: * Also for transfer these values are different. So it is
2185: * better to separate them out.
2186: */
2187: PROCEDURE default_from_subloc_info(
2188: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2189: n IN BINARY_INTEGER
2190: ) IS
2191: l_from_subinventory rcv_transactions.from_subinventory%TYPE;
2192: l_from_locator_id rcv_transactions.from_locator_id%TYPE;

Line 2267: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2263: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2264: END default_from_subloc_info;
2265:
2266: PROCEDURE default_to_subloc_info(
2267: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2268: n IN BINARY_INTEGER
2269: ) IS
2270: l_from_subinventory rcv_transactions.from_subinventory%TYPE;
2271: l_from_locator_id rcv_transactions.from_locator_id%TYPE;

Line 2526: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2522: END default_to_subloc_info;
2523:
2524: /* WMS Change End */
2525: PROCEDURE derive_reason_info(
2526: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2527: n IN OUT NOCOPY BINARY_INTEGER
2528: ) IS
2529: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
2530: BEGIN

Line 2554: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2550: END IF;
2551: END derive_reason_info;
2552:
2553: PROCEDURE derive_auto_transact_code(
2554: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2555: n IN OUT NOCOPY BINARY_INTEGER
2556: ) IS
2557: BEGIN
2558: IF (x_cascaded_table(n).error_status IN('S', 'W')) THEN

Line 2663: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2659: END IF;
2660: END derive_auto_transact_code;
2661:
2662: PROCEDURE derive_vendor_rcv_line_qty(
2663: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2664: n IN OUT NOCOPY BINARY_INTEGER,
2665: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2666: x_header_record IN rcv_roi_preprocessor.header_rec_type
2667: ) IS

Line 2665: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2661:
2662: PROCEDURE derive_vendor_rcv_line_qty(
2663: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2664: n IN OUT NOCOPY BINARY_INTEGER,
2665: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2666: x_header_record IN rcv_roi_preprocessor.header_rec_type
2667: ) IS
2668: x_include_closed_po VARCHAR2(1); -- Bug 1887728
2669:

Line 2666: x_header_record IN rcv_roi_preprocessor.header_rec_type

2662: PROCEDURE derive_vendor_rcv_line_qty(
2663: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2664: n IN OUT NOCOPY BINARY_INTEGER,
2665: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2666: x_header_record IN rcv_roi_preprocessor.header_rec_type
2667: ) IS
2668: x_include_closed_po VARCHAR2(1); -- Bug 1887728
2669:
2670: /* R12 Complex Work.

Line 5231: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

5227: END IF;
5228: END derive_vendor_rcv_line_qty;
5229:
5230: PROCEDURE derive_vendor_rcv_line_amt(
5231: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5232: n IN OUT NOCOPY BINARY_INTEGER,
5233: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5234: x_header_record IN rcv_roi_preprocessor.header_rec_type
5235: ) IS

Line 5233: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

5229:
5230: PROCEDURE derive_vendor_rcv_line_amt(
5231: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5232: n IN OUT NOCOPY BINARY_INTEGER,
5233: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5234: x_header_record IN rcv_roi_preprocessor.header_rec_type
5235: ) IS
5236: x_include_closed_po VARCHAR2(1); -- Bug 1887728
5237:

Line 5234: x_header_record IN rcv_roi_preprocessor.header_rec_type

5230: PROCEDURE derive_vendor_rcv_line_amt(
5231: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5232: n IN OUT NOCOPY BINARY_INTEGER,
5233: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
5234: x_header_record IN rcv_roi_preprocessor.header_rec_type
5235: ) IS
5236: x_include_closed_po VARCHAR2(1); -- Bug 1887728
5237:
5238: CURSOR shipments(

Line 6672: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6668: END IF;
6669: END derive_vendor_rcv_line_amt;
6670:
6671: PROCEDURE validate_transaction_date(
6672: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6673: n IN BINARY_INTEGER
6674: ) IS
6675: x_val_open_ok BOOLEAN := NULL;
6676: x_sob_id NUMBER := NULL;

Line 6782: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6778: );
6779: END validate_transaction_date;
6780:
6781: PROCEDURE validate_quantity_invoiced(
6782: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6783: n IN BINARY_INTEGER
6784: ) IS
6785: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
6786: BEGIN

Line 6804: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6800: );
6801: END validate_quantity_invoiced;
6802:
6803: PROCEDURE validate_transaction_uom(
6804: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6805: n IN BINARY_INTEGER
6806: ) IS
6807: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
6808: BEGIN

Line 6843: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6839: );
6840: END validate_transaction_uom;
6841:
6842: PROCEDURE validate_item_info(
6843: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6844: n IN BINARY_INTEGER
6845: ) IS
6846: item_revision_record rcv_shipment_line_sv.item_id_record_type;
6847: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

Line 6939: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6935: NULL;
6936: END validate_item_info;
6937:
6938: PROCEDURE validate_freight_carrier_code(
6939: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6940: n IN BINARY_INTEGER
6941: ) IS
6942: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
6943: BEGIN

Line 6971: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6967: END IF; --}
6968: END validate_freight_carrier_code;
6969:
6970: PROCEDURE validate_dest_type(
6971: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6972: n IN BINARY_INTEGER
6973: ) IS
6974: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
6975: BEGIN

Line 7002: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

6998: );
6999: END validate_dest_type;
7000:
7001: PROCEDURE validate_ship_to_loc(
7002: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7003: n IN BINARY_INTEGER
7004: ) IS
7005: location_record rcv_shipment_line_sv.location_record_type;
7006: BEGIN

Line 7036: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7032: );
7033: END validate_ship_to_loc;
7034:
7035: PROCEDURE validate_deliver_to_person(
7036: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7037: n IN BINARY_INTEGER
7038: ) IS
7039: employee_record rcv_shipment_line_sv.employee_record_type;
7040: BEGIN

Line 7093: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7089: */
7090: END validate_deliver_to_person;
7091:
7092: PROCEDURE validate_routing_record(
7093: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7094: n IN BINARY_INTEGER
7095: ) IS
7096: x_error_status VARCHAR2(1);
7097: BEGIN

Line 7150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7146: );
7147: END validate_routing_record;
7148:
7149: PROCEDURE validate_deliver_to_loc(
7150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7151: n IN BINARY_INTEGER
7152: ) IS
7153: location_record rcv_shipment_line_sv.location_record_type;
7154: BEGIN

Line 7189: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7185: END validate_deliver_to_loc;
7186:
7187: /* WMS Changes */
7188: PROCEDURE validate_subinventory(
7189: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7190: n IN BINARY_INTEGER
7191: ) IS
7192: x_subinventory VARCHAR2(10) := NULL;
7193: l_api_version CONSTANT NUMBER := 1.0;

Line 7327: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7323: rcv_error_pkg.log_interface_error('SUBINVENTORY', FALSE);
7324: END validate_subinventory;
7325:
7326: PROCEDURE validate_locator(
7327: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7328: n IN BINARY_INTEGER
7329: ) IS
7330: locator_record rcv_shipment_line_sv.locator_record_type;
7331: BEGIN

Line 7413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7409: END IF;
7410: END validate_locator;
7411:
7412: PROCEDURE validate_tax_code(
7413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7414: n IN BINARY_INTEGER,
7415: /* Bug3454491 (4) */
7416: x_asn_type IN rcv_headers_interface.asn_type%TYPE
7417: ) IS

Line 7446: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7442: END IF;
7443: END validate_tax_code;
7444:
7445: PROCEDURE validate_country_of_origin(
7446: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7447: n IN BINARY_INTEGER
7448: ) IS
7449: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
7450: BEGIN

Line 7476: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7472: END IF;
7473: END validate_country_of_origin;
7474:
7475: PROCEDURE validate_asl(
7476: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7477: n IN BINARY_INTEGER
7478: ) IS
7479: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
7480: BEGIN

Line 7507: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7503: );
7504: END validate_asl;
7505:
7506: PROCEDURE validate_shipped_qty(
7507: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7508: n IN BINARY_INTEGER
7509: ) IS
7510: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
7511: BEGIN

Line 7545: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7541: END IF; -- vendor_cum_shipped_qty <> 0
7542: END validate_shipped_qty;
7543:
7544: PROCEDURE validate_ref_integrity(
7545: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7546: n IN BINARY_INTEGER,
7547: x_header_record IN rcv_roi_preprocessor.header_rec_type
7548: ) IS
7549: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;

Line 7547: x_header_record IN rcv_roi_preprocessor.header_rec_type

7543:
7544: PROCEDURE validate_ref_integrity(
7545: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7546: n IN BINARY_INTEGER,
7547: x_header_record IN rcv_roi_preprocessor.header_rec_type
7548: ) IS
7549: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
7550: l_job_id po_lines.job_id%TYPE;
7551: l_item_description po_lines.item_description%TYPE;

Line 7765: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7761: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
7762: END validate_ref_integrity;
7763:
7764: PROCEDURE exchange_sub_items(
7765: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7766: n IN BINARY_INTEGER
7767: ) IS
7768: location_record rcv_shipment_line_sv.location_record_type;
7769: x_item_id NUMBER;

Line 7882: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7878: END IF;
7879: END exchange_sub_items;
7880:
7881: PROCEDURE validate_consigned_inventory(
7882: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7883: n IN BINARY_INTEGER,
7884: /* Bug3454491 (5) */
7885: x_asn_type IN rcv_headers_interface.asn_type%TYPE
7886: ) IS

Line 7991: x_header_record IN rcv_roi_preprocessor.header_rec_type

7987: END validate_consigned_inventory;
7988:
7989: PROCEDURE validate_ref_integ(
7990: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
7991: x_header_record IN rcv_roi_preprocessor.header_rec_type
7992: ) IS
7993: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
7994: x_po_line_id po_lines.po_line_id%TYPE;
7995: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;

Line 8121: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8117: END IF;
8118: END validate_ref_integ;
8119:
8120: PROCEDURE validate_temp_labor_info(
8121: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8122: n IN BINARY_INTEGER,
8123: v_header_record IN rcv_roi_preprocessor.header_rec_type
8124: ) IS
8125: x_error_status VARCHAR2(1);

Line 8123: v_header_record IN rcv_roi_preprocessor.header_rec_type

8119:
8120: PROCEDURE validate_temp_labor_info(
8121: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8122: n IN BINARY_INTEGER,
8123: v_header_record IN rcv_roi_preprocessor.header_rec_type
8124: ) IS
8125: x_error_status VARCHAR2(1);
8126: BEGIN
8127: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 8153: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8149: END IF;
8150: END validate_temp_labor_info;
8151:
8152: PROCEDURE validate_amount(
8153: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8154: n IN BINARY_INTEGER,
8155: v_header_record IN rcv_roi_preprocessor.header_rec_type
8156: ) IS
8157: x_error_status VARCHAR2(1);

Line 8155: v_header_record IN rcv_roi_preprocessor.header_rec_type

8151:
8152: PROCEDURE validate_amount(
8153: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8154: n IN BINARY_INTEGER,
8155: v_header_record IN rcv_roi_preprocessor.header_rec_type
8156: ) IS
8157: x_error_status VARCHAR2(1);
8158: BEGIN
8159: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 8183: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

8179: END IF;
8180: END validate_amount;
8181:
8182: PROCEDURE handle_rcv_asn_transactions(
8183: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8184: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
8185: ) IS
8186: v_current_interface_id NUMBER;
8187: v_prior_interface_id NUMBER;

Line 8184: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

8180: END validate_amount;
8181:
8182: PROCEDURE handle_rcv_asn_transactions(
8183: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8184: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
8185: ) IS
8186: v_current_interface_id NUMBER;
8187: v_prior_interface_id NUMBER;
8188: i BINARY_INTEGER := 0;

Line 9083: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9079: END IF;
9080: END handle_rcv_asn_transactions;
9081:
9082: PROCEDURE derive_vendor_trans_del(
9083: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9084: n IN OUT NOCOPY BINARY_INTEGER,
9085: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9086: x_header_record IN rcv_roi_preprocessor.header_rec_type
9087: ) IS

Line 9085: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9081:
9082: PROCEDURE derive_vendor_trans_del(
9083: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9084: n IN OUT NOCOPY BINARY_INTEGER,
9085: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9086: x_header_record IN rcv_roi_preprocessor.header_rec_type
9087: ) IS
9088: test NUMBER;
9089: BEGIN

Line 9086: x_header_record IN rcv_roi_preprocessor.header_rec_type

9082: PROCEDURE derive_vendor_trans_del(
9083: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9084: n IN OUT NOCOPY BINARY_INTEGER,
9085: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9086: x_header_record IN rcv_roi_preprocessor.header_rec_type
9087: ) IS
9088: test NUMBER;
9089: BEGIN
9090: IF (g_asn_debug = 'Y') THEN

Line 9139: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9135: );
9136: END derive_vendor_trans_del;
9137:
9138: PROCEDURE derive_parent_id(
9139: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9140: n IN OUT NOCOPY BINARY_INTEGER
9141: ) IS
9142: derive_values_from_plsql_table BOOLEAN := FALSE;
9143: cascaded_table_index NUMBER;

Line 9320: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

9316: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
9317: END derive_parent_id;
9318:
9319: PROCEDURE derive_trans_del_line_quantity(
9320: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9321: n IN OUT NOCOPY BINARY_INTEGER,
9322: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
9323: ) IS
9324: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 9322: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

9318:
9319: PROCEDURE derive_trans_del_line_quantity(
9320: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
9321: n IN OUT NOCOPY BINARY_INTEGER,
9322: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
9323: ) IS
9324: x_include_closed_po VARCHAR2(1); -- Bug 1887728
9325: /*
9326: ** Might be a compatibility issue between the two record definitions

Line 11453: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

11449: * but since the code is the same for RMAs, the cursor has been expanded
11450: * to include RMA information as well and the procedure reused for RMAs.
11451: */
11452: PROCEDURE default_vendor_trans_del(
11453: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11454: n IN BINARY_INTEGER
11455: ) IS
11456: p_trx_record rcv_roi_header_common.common_default_record_type;
11457:

Line 11836: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

11832: END default_vendor_trans_del;
11833:
11834:
11835: PROCEDURE derive_correction_line(
11836: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11837: n IN OUT NOCOPY BINARY_INTEGER,
11838: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11839: x_header_record IN rcv_roi_preprocessor.header_rec_type
11840: ) IS

Line 11838: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

11834:
11835: PROCEDURE derive_correction_line(
11836: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11837: n IN OUT NOCOPY BINARY_INTEGER,
11838: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11839: x_header_record IN rcv_roi_preprocessor.header_rec_type
11840: ) IS
11841: l_po_header_id po_headers_all.po_header_id%type;
11842: l_return_status VARCHAR2(1) :='S';

Line 11839: x_header_record IN rcv_roi_preprocessor.header_rec_type

11835: PROCEDURE derive_correction_line(
11836: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11837: n IN OUT NOCOPY BINARY_INTEGER,
11838: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11839: x_header_record IN rcv_roi_preprocessor.header_rec_type
11840: ) IS
11841: l_po_header_id po_headers_all.po_header_id%type;
11842: l_return_status VARCHAR2(1) :='S';
11843: l_complex_flag varchar2(1);

Line 11976: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

11972: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
11973: END derive_correction_line;
11974:
11975: PROCEDURE derive_correction_line_qty(
11976: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11977: n IN OUT NOCOPY BINARY_INTEGER,
11978: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
11979: ) IS
11980: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 11978: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

11974:
11975: PROCEDURE derive_correction_line_qty(
11976: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11977: n IN OUT NOCOPY BINARY_INTEGER,
11978: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
11979: ) IS
11980: x_include_closed_po VARCHAR2(1); -- Bug 1887728
11981: /*
11982: ** Might be a compatibility issue between the two record definitions

Line 13134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

13130: END IF;
13131: END derive_correction_line_qty;
13132:
13133: PROCEDURE derive_correction_line_amt(
13134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13135: n IN OUT NOCOPY BINARY_INTEGER,
13136: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
13137: ) IS
13138: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 13136: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

13132:
13133: PROCEDURE derive_correction_line_amt(
13134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13135: n IN OUT NOCOPY BINARY_INTEGER,
13136: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
13137: ) IS
13138: x_include_closed_po VARCHAR2(1); -- Bug 1887728
13139: /*
13140: ** Might be a compatibility issue between the two record definitions

Line 14142: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14138: END IF;
14139: END derive_correction_line_amt;
14140:
14141: PROCEDURE default_vendor_correct(
14142: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14143: n IN BINARY_INTEGER
14144: ) IS
14145: p_trx_record rcv_roi_header_common.common_default_record_type;
14146:

Line 14552: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14548: RETURN(correct_qty);
14549: END;
14550:
14551: PROCEDURE validate_source_type(
14552: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14553: n IN BINARY_INTEGER
14554: ) IS
14555: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
14556: BEGIN

Line 14601: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14597: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
14598: END validate_source_type;
14599:
14600: PROCEDURE validate_transaction_type(
14601: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14602: n IN BINARY_INTEGER
14603: ) IS
14604: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
14605: BEGIN

Line 14637: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14633: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
14634: END validate_transaction_type;
14635:
14636: PROCEDURE validate_inspection_status(
14637: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14638: n IN BINARY_INTEGER
14639: ) IS
14640: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
14641: BEGIN

Line 14676: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14672: /** OPM change Bug# 3061052**/
14673: -- added validate_opm_attributes to validate OPM specific columns.
14674:
14675: PROCEDURE validate_opm_attributes(
14676: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14677: n IN BINARY_INTEGER
14678: ) IS
14679: /*INVCONV, gml_opm_roi_grp.opm_record_type to be removed , Punit Kumar */
14680: --l_opm_record_type gml_opm_roi_grp.opm_record_type;

Line 14950: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

14946: END validate_opm_attributes;
14947:
14948:
14949: PROCEDURE get_interface_available_qty(
14950: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
14951: n IN BINARY_INTEGER,
14952: x_interface_qty OUT NOCOPY NUMBER
14953: ) IS
14954: l_grandparent_interface_trx_id NUMBER;

Line 15034: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15030: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
15031: END get_interface_available_qty;
15032:
15033: PROCEDURE get_interface_available_amt(
15034: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15035: n IN BINARY_INTEGER,
15036: x_interface_amt OUT NOCOPY NUMBER
15037: ) IS
15038: l_grandparent_interface_trx_id NUMBER;

Line 15104: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15100: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
15101: END get_interface_available_amt;
15102:
15103: PROCEDURE update_interface_available_qty(
15104: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15105: n IN BINARY_INTEGER
15106: ) IS
15107: l_grandparent_interface_trx_id NUMBER;
15108: l_parent_trx_type rcv_transactions_interface.transaction_type%TYPE;

Line 15187: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15183: rcv_error_pkg.log_interface_error('TRANSACTIONS_INTERFACE_ID', FALSE);
15184: END update_interface_available_qty;
15185:
15186: PROCEDURE update_interface_available_amt(
15187: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15188: n IN BINARY_INTEGER
15189: ) IS
15190: l_grandparent_interface_trx_id NUMBER;
15191: l_parent_trx_type rcv_transactions_interface.transaction_type%TYPE;

Line 15413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15409: RAISE;
15410: END update_total_transaction_amt;
15411:
15412: PROCEDURE derive_matching_basis(
15413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15414: n IN BINARY_INTEGER
15415: ) IS
15416: x_progress varchar2(3);
15417: begin

Line 15610: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15606: Purchase order. If po_distribution_id is not known, it will try to get the
15607: value based on po_line_location only if the poll has got single distribution.
15608: */
15609: PROCEDURE get_deliver_to_person_from_po(
15610: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15611: n IN BINARY_INTEGER
15612: ) IS
15613: l_deliver_to_person_id NUMBER;
15614: l_distribution_count NUMBER;

Line 15685: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15681: This function is called from validate_vendor_rcv_line() and it tries to default
15682: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions).
15683: */
15684: FUNCTION get_deliver_to_person_from_rt(
15685: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15686: n IN BINARY_INTEGER
15687: ) RETURN NUMBER IS
15688: l_parent_deliver_to_person_id NUMBER := null;
15689: BEGIN

Line 15713: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

15709: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions_interface).
15710: */
15711:
15712: FUNCTION get_deliver_to_person_from_rti(
15713: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15714: n IN BINARY_INTEGER
15715: ) RETURN NUMBER IS
15716: l_parent_deliver_to_person_id NUMBER := null;
15717: BEGIN

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

15732: return null;
15733: END get_deliver_to_person_from_rti;
15734:
15735: PROCEDURE validate_lcm_line
15736: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15737: n IN binary_integer,
15738: x_asn_type IN rcv_headers_interface.asn_type%type,
15739: x_header_record IN rcv_roi_preprocessor.header_rec_type
15740: ) IS

Line 15739: x_header_record IN rcv_roi_preprocessor.header_rec_type

15735: PROCEDURE validate_lcm_line
15736: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15737: n IN binary_integer,
15738: x_asn_type IN rcv_headers_interface.asn_type%type,
15739: x_header_record IN rcv_roi_preprocessor.header_rec_type
15740: ) IS
15741:
15742: l_pre_rcv_flag VARCHAR2(1);
15743: l_lcm_shipment_flag VARCHAR2(1);