DBA Data[Home] [Help]

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

1975: PROCEDURE default_item_info(
1976: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1977: n IN BINARY_INTEGER
1978: ) IS
1979: item_id_record rcv_shipment_line_sv.item_id_record_type;
1980: l_category_set_id mtl_category_sets_b.category_set_id%TYPE;
1981: BEGIN
1982: -- default the item_revision
1983:

Line 2424: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;

2420: PROCEDURE validate_uom_info(
2421: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2422: n IN BINARY_INTEGER
2423: ) IS
2424: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
2425: BEGIN
2426: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2427: RETURN;
2428: END IF;

Line 2467: item_revision_record rcv_shipment_line_sv.item_id_record_type;

2463: PROCEDURE validate_item_info(
2464: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2465: n IN BINARY_INTEGER
2466: ) IS
2467: item_revision_record rcv_shipment_line_sv.item_id_record_type;
2468: item_id_record rcv_shipment_line_sv.item_id_record_type;
2469: BEGIN
2470: -- item_id
2471: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 2468: item_id_record rcv_shipment_line_sv.item_id_record_type;

2464: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2465: n IN BINARY_INTEGER
2466: ) IS
2467: item_revision_record rcv_shipment_line_sv.item_id_record_type;
2468: item_id_record rcv_shipment_line_sv.item_id_record_type;
2469: BEGIN
2470: -- item_id
2471: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2472: RETURN;

Line 2750: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

2746: PROCEDURE validate_freight_carrier_code(
2747: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2748: n IN BINARY_INTEGER
2749: ) IS
2750: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
2751: BEGIN
2752: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2753: RETURN;
2754: END IF;

Line 2781: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

2777: PROCEDURE validate_destination_type(
2778: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2779: n IN BINARY_INTEGER
2780: ) IS
2781: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
2782: BEGIN
2783: /*
2784: ** Validate Destination Type. This value is always required
2785: */

Line 2812: employee_record rcv_shipment_line_sv.employee_record_type;

2808: PROCEDURE validate_deliver_to_info(
2809: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2810: n IN BINARY_INTEGER
2811: ) IS
2812: employee_record rcv_shipment_line_sv.employee_record_type;
2813: BEGIN
2814: /*
2815: ** Validate deliver to person. This value is always optional
2816: */

Line 2859: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;

2855: PROCEDURE validate_country_of_origin(
2856: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2857: n IN BINARY_INTEGER
2858: ) IS
2859: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
2860: BEGIN
2861: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2862: RETURN;
2863: END IF;

Line 2896: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

2892: Copied from rcv_transactions_interface_sv1 and modified for RMA use
2893:
2894: ===========================================================================*/
2895: PROCEDURE validate_item(
2896: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
2897: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2898: ) IS -- bug 608353
2899: x_progress VARCHAR2(3);
2900: x_inventory_item mtl_system_items.inventory_item_id%TYPE;

Line 3023: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

3019: Copied from rcv_transactions_interface_sv1 and modified for RMA use
3020:
3021: ===========================================================================*/
3022: PROCEDURE validate_item_revision(
3023: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
3024: ) IS
3025: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
3026: x_progress VARCHAR2(3);
3027: x_revision_control_flag VARCHAR2(1);

Line 3181: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type

3177: END validate_ref_integrity;
3178:
3179: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3180: PROCEDURE validate_uom(
3181: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
3182: ) IS
3183: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
3184: x_unit_meas_lookup_code_lines po_lines_all.unit_meas_lookup_code%TYPE := NULL;
3185: x_progress VARCHAR2(3);

Line 3289: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

3285: END IF;
3286: END validate_uom;
3287:
3288: PROCEDURE default_item_revision(
3289: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
3290: ) IS
3291: x_revision_control_flag VARCHAR2(1);
3292: x_number_of_inv_dest NUMBER;
3293: x_item_rev_exists BOOLEAN;

Line 3468: x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type

3464: PROCEDURE NAME: get_locator_id()
3465:
3466: ===========================================================================*/
3467: PROCEDURE get_locator_id(
3468: x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type
3469: ) IS
3470: BEGIN
3471: IF (g_asn_debug = 'Y') THEN
3472: asn_debug.put_line('inside get_locator_id');

Line 3514: x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type

3510: PROCEDURE NAME: get_routing_header_id()
3511:
3512: ===========================================================================*/
3513: PROCEDURE get_routing_header_id(
3514: x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type
3515: ) IS
3516: BEGIN
3517: SELECT MAX(routing_header_id)
3518: INTO x_routing_header_id_record.routing_header_id

Line 3539: x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type

3535: PROCEDURE NAME: get_routing_step_id()
3536:
3537: ===========================================================================*/
3538: PROCEDURE get_routing_step_id(
3539: x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type
3540: ) IS
3541: BEGIN
3542: SELECT MAX(routing_step_id)
3543: INTO x_routing_step_id_record.routing_step_id

Line 3564: x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type

3560: PROCEDURE NAME: get_reason_id()
3561:
3562: ===========================================================================*/
3563: PROCEDURE get_reason_id(
3564: x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type
3565: ) IS
3566: BEGIN
3567: SELECT MAX(reason_id)
3568: INTO x_reason_id_record.reason_id

Line 3589: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

3585: PROCEDURE NAME: get_item_id()
3586:
3587: ===========================================================================*/
3588: PROCEDURE get_item_id(
3589: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
3590: ) IS
3591: BEGIN
3592: IF (x_item_id_record.item_num IS NOT NULL) THEN
3593: SELECT MIN(inventory_item_id),