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_SHIPMENT_LINE_SV

Line 209: item_id_record rcv_shipment_line_sv.item_id_record_type;

205: x_success BOOLEAN;
206: x_tax_name VARCHAR2(50); -- Bug 6331613
207: x_vendor_site_id NUMBER;
208: x_vendor_site_code VARCHAR2(20);
209: item_id_record rcv_shipment_line_sv.item_id_record_type;
210:
211: /* bug2382337:
212: * Change the name of the parameters passed into the cursor
213: */

Line 1299: document_num_record rcv_shipment_line_sv.document_num_record_type;

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;
1300: BEGIN
1301: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1302: AND ( x_cascaded_table(n).po_header_id IS NULL
1303: AND x_cascaded_table(n).document_num IS NOT NULL) THEN

Line 1379: item_id_record rcv_shipment_line_sv.item_id_record_type;

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
1381: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1382: AND ( x_cascaded_table(n).item_id IS NULL
1383: AND (x_cascaded_table(n).item_num IS NOT NULL)) THEN

Line 1416: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

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
1418: /* FPJ Services.
1419: * We do not support Substitute Receipts for service POs.
1420: */

Line 1461: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;

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;
1463: l_asn_type rcv_shipment_headers.asn_type%type;
1464: l_error_column VARCHAR2(30); --Bugfix 4881909
1465: BEGIN

Line 1462: release_id_record rcv_shipment_line_sv.release_id_record_type;

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;
1463: l_asn_type rcv_shipment_headers.asn_type%type;
1464: l_error_column VARCHAR2(30); --Bugfix 4881909
1465: BEGIN
1466: IF (g_asn_debug = 'Y') THEN

Line 1910: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;

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
1912: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1913: AND ( x_cascaded_table(n).routing_header_id IS NULL
1914: AND x_cascaded_table(n).routing_code IS NOT NULL) THEN

Line 1938: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;

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
1940: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1941: AND ( x_cascaded_table(n).routing_step_id IS NULL
1942: AND x_cascaded_table(n).routing_step IS NOT NULL) THEN

Line 2529: reason_id_record rcv_shipment_line_sv.reason_id_record_type;

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
2531: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2532: AND ( x_cascaded_table(n).reason_id IS NULL
2533: AND x_cascaded_table(n).reason_name IS NOT NULL) THEN

Line 6785: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;

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
6787: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
6788: RETURN;
6789: END IF;

Line 6807: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;

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
6809: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
6810: RETURN;
6811: END IF;

Line 6846: item_revision_record rcv_shipment_line_sv.item_id_record_type;

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;
6848: item_id_record rcv_shipment_line_sv.item_id_record_type;
6849: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
6850: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511

Line 6847: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

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;
6848: item_id_record rcv_shipment_line_sv.item_id_record_type;
6849: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
6850: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
6851: BEGIN

Line 6848: item_id_record rcv_shipment_line_sv.item_id_record_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;
6848: item_id_record rcv_shipment_line_sv.item_id_record_type;
6849: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
6850: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
6851: BEGIN
6852: -- validate item id

Line 6942: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

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
6944: --validate freight carrier code
6945: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
6946: RETURN;

Line 6974: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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
6976: /*
6977: ** Validate Destination Type. This value is always required
6978: */

Line 7005: location_record rcv_shipment_line_sv.location_record_type;

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
7007: /*
7008: ** Validate ship_to_location. This value is always required
7009: */

Line 7039: employee_record rcv_shipment_line_sv.employee_record_type;

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
7041: /*
7042: ** Validate deliver to person. This value is always optional
7043: */

Line 7153: location_record rcv_shipment_line_sv.location_record_type;

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
7155: /*
7156: ** Validate deliver_to_location. If this is an expense or shop floor
7157: ** destination then the value is required

Line 7330: locator_record rcv_shipment_line_sv.locator_record_type;

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
7332: /*
7333: ** Validate locator if inventory destination or if not inventory
7334: ** destintion make sure to null out the locator_id

Line 7418: tax_name_record rcv_shipment_line_sv.tax_name_record_type;

7414: n IN BINARY_INTEGER,
7415: /* Bug3454491 (4) */
7416: x_asn_type IN rcv_headers_interface.asn_type%TYPE
7417: ) IS
7418: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
7419: BEGIN
7420: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7421: RETURN;
7422: END IF;

Line 7449: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;

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
7451: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7452: RETURN;
7453: END IF;

Line 7479: asl_record rcv_shipment_line_sv.ref_integrity_record_type;

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
7481: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7482: RETURN;
7483: END IF;

Line 7510: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;

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
7512: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7513: RETURN;
7514: END IF;

Line 7549: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;

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;
7552: l_category_id po_lines.category_id%TYPE;
7553: x_error_status VARCHAR2(1);

Line 7768: location_record rcv_shipment_line_sv.location_record_type;

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;
7770: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;
7771: x_uom_class VARCHAR2(10);
7772: x_uom_count NUMBER(10);

Line 7887: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;

7883: n IN BINARY_INTEGER,
7884: /* Bug3454491 (5) */
7885: x_asn_type IN rcv_headers_interface.asn_type%TYPE
7886: ) IS
7887: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
7888: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
7889: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
7890: BEGIN
7891: /* */

Line 7888: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;

7884: /* Bug3454491 (5) */
7885: x_asn_type IN rcv_headers_interface.asn_type%TYPE
7886: ) IS
7887: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
7888: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
7889: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
7890: BEGIN
7891: /* */
7892:

Line 7889: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;

7885: x_asn_type IN rcv_headers_interface.asn_type%TYPE
7886: ) IS
7887: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
7888: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
7889: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
7890: BEGIN
7891: /* */
7892:
7893: /* Reject ASBN transaction if it's a shipment against Consigned PO */

Line 7990: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,

7986: NULL;
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;

Line 14555: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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
14557: /*
14558: ** Validate Source Type. This value is always required
14559: */

Line 14604: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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
14606: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
14607: RETURN;
14608: END IF;

Line 14640: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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
14642: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
14643: RETURN;
14644: END IF;