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_RMA_TRANSACTIONS dependencies on RCV_SHIPMENT_LINE_SV

Line 268: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type

264: n IN BINARY_INTEGER
265: );
266:
267: PROCEDURE validate_uom(
268: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
269: );
270:
271: PROCEDURE validate_item(
272: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

Line 272: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

268: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
269: );
270:
271: PROCEDURE validate_item(
272: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
273: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
274: );
275:
276: -- main public procedures

Line 1945: item_id_record rcv_shipment_line_sv.item_id_record_type;

1941: PROCEDURE default_item_info(
1942: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1943: n IN BINARY_INTEGER
1944: ) IS
1945: item_id_record rcv_shipment_line_sv.item_id_record_type;
1946: l_category_set_id mtl_category_sets_b.category_set_id%TYPE;
1947: BEGIN
1948: -- default the item_revision
1949:

Line 2390: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;

2386: PROCEDURE validate_uom_info(
2387: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2388: n IN BINARY_INTEGER
2389: ) IS
2390: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
2391: BEGIN
2392: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2393: RETURN;
2394: END IF;

Line 2433: item_revision_record rcv_shipment_line_sv.item_id_record_type;

2429: PROCEDURE validate_item_info(
2430: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2431: n IN BINARY_INTEGER
2432: ) IS
2433: item_revision_record rcv_shipment_line_sv.item_id_record_type;
2434: item_id_record rcv_shipment_line_sv.item_id_record_type;
2435: BEGIN
2436: -- item_id
2437: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 2434: item_id_record rcv_shipment_line_sv.item_id_record_type;

2430: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2431: n IN BINARY_INTEGER
2432: ) IS
2433: item_revision_record rcv_shipment_line_sv.item_id_record_type;
2434: item_id_record rcv_shipment_line_sv.item_id_record_type;
2435: BEGIN
2436: -- item_id
2437: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2438: RETURN;

Line 2611: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

2607: PROCEDURE validate_freight_carrier_code(
2608: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2609: n IN BINARY_INTEGER
2610: ) IS
2611: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
2612: BEGIN
2613: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2614: RETURN;
2615: END IF;

Line 2642: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

2638: PROCEDURE validate_destination_type(
2639: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2640: n IN BINARY_INTEGER
2641: ) IS
2642: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
2643: BEGIN
2644: /*
2645: ** Validate Destination Type. This value is always required
2646: */

Line 2673: employee_record rcv_shipment_line_sv.employee_record_type;

2669: PROCEDURE validate_deliver_to_info(
2670: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2671: n IN BINARY_INTEGER
2672: ) IS
2673: employee_record rcv_shipment_line_sv.employee_record_type;
2674: BEGIN
2675: /*
2676: ** Validate deliver to person. This value is always optional
2677: */

Line 2720: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;

2716: PROCEDURE validate_country_of_origin(
2717: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2718: n IN BINARY_INTEGER
2719: ) IS
2720: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
2721: BEGIN
2722: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2723: RETURN;
2724: END IF;

Line 2757: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

2753: Copied from rcv_transactions_interface_sv1 and modified for RMA use
2754:
2755: ===========================================================================*/
2756: PROCEDURE validate_item(
2757: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
2758: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2759: ) IS -- bug 608353
2760: x_progress VARCHAR2(3);
2761: x_inventory_item mtl_system_items.inventory_item_id%TYPE;

Line 2883: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

2879: Copied from rcv_transactions_interface_sv1 and modified for RMA use
2880:
2881: ===========================================================================*/
2882: PROCEDURE validate_item_revision(
2883: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
2884: ) IS
2885: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2886: x_progress VARCHAR2(3);
2887: x_revision_control_flag VARCHAR2(1);

Line 3041: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type

3037: END validate_ref_integrity;
3038:
3039: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3040: PROCEDURE validate_uom(
3041: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
3042: ) IS
3043: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
3044: x_unit_meas_lookup_code_lines po_lines_all.unit_meas_lookup_code%TYPE := NULL;
3045: x_progress VARCHAR2(3);

Line 3149: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

3145: END IF;
3146: END validate_uom;
3147:
3148: PROCEDURE default_item_revision(
3149: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
3150: ) IS
3151: x_revision_control_flag VARCHAR2(1);
3152: x_number_of_inv_dest NUMBER;
3153: x_item_rev_exists BOOLEAN;

Line 3328: x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type

3324: PROCEDURE NAME: get_locator_id()
3325:
3326: ===========================================================================*/
3327: PROCEDURE get_locator_id(
3328: x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type
3329: ) IS
3330: BEGIN
3331: IF (g_asn_debug = 'Y') THEN
3332: asn_debug.put_line('inside get_locator_id');

Line 3374: x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type

3370: PROCEDURE NAME: get_routing_header_id()
3371:
3372: ===========================================================================*/
3373: PROCEDURE get_routing_header_id(
3374: x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type
3375: ) IS
3376: BEGIN
3377: SELECT MAX(routing_header_id)
3378: INTO x_routing_header_id_record.routing_header_id

Line 3399: x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type

3395: PROCEDURE NAME: get_routing_step_id()
3396:
3397: ===========================================================================*/
3398: PROCEDURE get_routing_step_id(
3399: x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type
3400: ) IS
3401: BEGIN
3402: SELECT MAX(routing_step_id)
3403: INTO x_routing_step_id_record.routing_step_id

Line 3424: x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type

3420: PROCEDURE NAME: get_reason_id()
3421:
3422: ===========================================================================*/
3423: PROCEDURE get_reason_id(
3424: x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type
3425: ) IS
3426: BEGIN
3427: SELECT MAX(reason_id)
3428: INTO x_reason_id_record.reason_id

Line 3449: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

3445: PROCEDURE NAME: get_item_id()
3446:
3447: ===========================================================================*/
3448: PROCEDURE get_item_id(
3449: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
3450: ) IS
3451: BEGIN
3452: IF (x_item_id_record.item_num IS NOT NULL) THEN
3453: SELECT MIN(inventory_item_id),