[Home] [Help]
2: /* $Header: RCVTISVB.pls 120.3 2007/12/12 19:47:04 vthevark ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6: cascaded_table rcv_shipment_object_sv.cascaded_trans_tab_type;
7: transaction_record rcv_shipment_line_sv.transaction_record_type;
8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
55: PROCEDURE NAME: derive_shipment_line()
56:
57: ===========================================================================*/
58: PROCEDURE derive_shipment_line(
59: x_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
60: n IN OUT NOCOPY BINARY_INTEGER,
61: temp_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
62: x_header_record IN rcv_shipment_header_sv.headerrectype
63: ) IS
57: ===========================================================================*/
58: PROCEDURE derive_shipment_line(
59: x_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
60: n IN OUT NOCOPY BINARY_INTEGER,
61: temp_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
62: x_header_record IN rcv_shipment_header_sv.headerrectype
63: ) IS
64: /*
65: ** Debug: Needed to add all the columns selected in the distributions cursor
2523: PROCEDURE NAME: default_shipment_line()
2524:
2525: ===========================================================================*/
2526: PROCEDURE default_shipment_line(
2527: x_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
2528: n IN BINARY_INTEGER,
2529: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
2530: x_header_record IN rcv_shipment_header_sv.headerrectype
2531: ) IS
3159: PROCEDURE NAME: validate_shipment_line()
3160:
3161: ===========================================================================*/
3162: PROCEDURE validate_shipment_line(
3163: x_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
3164: n IN BINARY_INTEGER,
3165: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
3166: x_header_record IN rcv_shipment_header_sv.headerrectype
3167: ) IS
3862: PROCEDURE NAME: get_location_id()
3863:
3864: ===========================================================================*/
3865: PROCEDURE get_location_id(
3866: x_location_id_record IN OUT NOCOPY rcv_shipment_object_sv.location_id_record_type
3867: ) IS
3868: BEGIN
3869: SELECT MAX(location_id)
3870: INTO x_location_id_record.location_id
4188: END IF;
4189: END check_shipto_enforcement;
4190:
4191: PROCEDURE exchange_sub_item(
4192: v_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
4193: n IN BINARY_INTEGER
4194: ) IS
4195: x_item_id NUMBER;
4196: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;