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 626: item_id_record rcv_shipment_line_sv.item_id_record_type;

622: x_success BOOLEAN;
623: x_tax_name VARCHAR2(50); -- Bug 6331613
624: x_vendor_site_id NUMBER;
625: x_vendor_site_code VARCHAR2(20);
626: item_id_record rcv_shipment_line_sv.item_id_record_type;
627:
628: /* bug2382337:
629: * Change the name of the parameters passed into the cursor
630: */

Line 1726: document_num_record rcv_shipment_line_sv.document_num_record_type;

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;
1727: BEGIN
1728: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1729: AND ( x_cascaded_table(n).po_header_id IS NULL
1730: AND x_cascaded_table(n).document_num IS NOT NULL) THEN

Line 1806: item_id_record rcv_shipment_line_sv.item_id_record_type;

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

Line 1843: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

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
1845: /* FPJ Services.
1846: * We do not support Substitute Receipts for service POs.
1847: */

Line 1888: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;

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;
1890: l_asn_type rcv_shipment_headers.asn_type%type;
1891: l_error_column VARCHAR2(30); --Bugfix 4881909
1892: l_is_clm_po VARCHAR2(5) := 'N'; --

Line 1889: release_id_record rcv_shipment_line_sv.release_id_record_type;

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;
1890: l_asn_type rcv_shipment_headers.asn_type%type;
1891: l_error_column VARCHAR2(30); --Bugfix 4881909
1892: l_is_clm_po VARCHAR2(5) := 'N'; --
1893: BEGIN

Line 2392: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;

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

Line 2420: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;

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

Line 3011: reason_id_record rcv_shipment_line_sv.reason_id_record_type;

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

Line 7538: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;

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

Line 7560: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;

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

Line 7599: item_revision_record rcv_shipment_line_sv.item_id_record_type;

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

Line 7600: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

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;
7601: item_id_record rcv_shipment_line_sv.item_id_record_type;
7602: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
7603: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
7604: BEGIN

Line 7601: item_id_record rcv_shipment_line_sv.item_id_record_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;
7601: item_id_record rcv_shipment_line_sv.item_id_record_type;
7602: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
7603: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
7604: BEGIN
7605: -- validate item id

Line 7697: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

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;
7698: BEGIN
7699: --validate freight carrier code
7700: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7701: RETURN;

Line 7756: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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
7758: /*
7759: ** Validate Destination Type. This value is always required
7760: */

Line 7787: location_record rcv_shipment_line_sv.location_record_type;

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
7789: /*
7790: ** Validate ship_to_location. This value is always required
7791: */

Line 7836: employee_record rcv_shipment_line_sv.employee_record_type;

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
7838: /*
7839: ** Validate deliver to person. This value is always optional
7840: */

Line 7995: location_record rcv_shipment_line_sv.location_record_type;

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

Line 8216: locator_record rcv_shipment_line_sv.locator_record_type;

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;
8218:
8219: BEGIN
8220: /*

Line 8361: tax_name_record rcv_shipment_line_sv.tax_name_record_type;

8357: n IN BINARY_INTEGER,
8358: /* Bug3454491 (4) */
8359: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8360: ) IS
8361: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
8362: BEGIN
8363: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
8364: RETURN;
8365: END IF;

Line 8392: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;

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

Line 8422: asl_record rcv_shipment_line_sv.ref_integrity_record_type;

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

Line 8453: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;

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

Line 8492: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;

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

Line 8711: location_record rcv_shipment_line_sv.location_record_type;

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

Line 8830: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;

8826: n IN BINARY_INTEGER,
8827: /* Bug3454491 (5) */
8828: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8829: ) IS
8830: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
8831: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
8832: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
8833: BEGIN
8834: /* */

Line 8831: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;

8827: /* Bug3454491 (5) */
8828: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8829: ) IS
8830: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
8831: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
8832: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
8833: BEGIN
8834: /* */
8835:

Line 8832: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;

8828: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8829: ) IS
8830: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
8831: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
8832: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
8833: BEGIN
8834: /* */
8835:
8836: /* Reject ASBN transaction if it's a shipment against Consigned PO */

Line 8933: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,

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

Line 15970: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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
15972: /*
15973: ** Validate Source Type. This value is always required
15974: */

Line 16019: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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

Line 16055: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

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