27: (
28: x_return_status OUT NOCOPY VARCHAR2
29: ,x_msg_count OUT NOCOPY NUMBER
30: ,x_msg_data OUT NOCOPY VARCHAR2
31: ,x_cascaded_table IN OUT NOCOPY INV_RCV_COMMON_APIS.cascaded_trans_tab_type
32: ,n IN OUT NOCOPY BINARY_INTEGER
33: ,temp_cascaded_table IN OUT NOCOPY INV_RCV_COMMON_APIS.cascaded_trans_tab_type
34: ,p_receipt_num IN VARCHAR2
35: ,p_match_type IN VARCHAR2
29: ,x_msg_count OUT NOCOPY NUMBER
30: ,x_msg_data OUT NOCOPY VARCHAR2
31: ,x_cascaded_table IN OUT NOCOPY INV_RCV_COMMON_APIS.cascaded_trans_tab_type
32: ,n IN OUT NOCOPY BINARY_INTEGER
33: ,temp_cascaded_table IN OUT NOCOPY INV_RCV_COMMON_APIS.cascaded_trans_tab_type
34: ,p_receipt_num IN VARCHAR2
35: ,p_match_type IN VARCHAR2
36: ,p_lpn_id IN NUMBER)
37: IS
34: ,p_receipt_num IN VARCHAR2
35: ,p_match_type IN VARCHAR2
36: ,p_lpn_id IN NUMBER)
37: IS
38: l_po_in_cascaded_table INV_RCV_COMMON_APIS.cascaded_trans_tab_type;
39: l_po_out_cascaded_table INV_RCV_COMMON_APIS.cascaded_trans_tab_type;
40:
41: l_shipment_line_id NUMBER;
42: l_category_id NUMBER;
35: ,p_match_type IN VARCHAR2
36: ,p_lpn_id IN NUMBER)
37: IS
38: l_po_in_cascaded_table INV_RCV_COMMON_APIS.cascaded_trans_tab_type;
39: l_po_out_cascaded_table INV_RCV_COMMON_APIS.cascaded_trans_tab_type;
40:
41: l_shipment_line_id NUMBER;
42: l_category_id NUMBER;
43: l_unit_of_measure VARCHAR2(30);
2023: /* FP-J Lot/Serial Support Enhancement
2024: * Read the currentand PO patch levels and set the flag (that would be used to
2025: * match the Lot Number and the LPN) accordingly
2026: */
2027: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2028: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2029: l_wms_po_j_or_higher := TRUE;
2030: l_patch_j_or_higher := 'Y';
2031: IF (l_debug = 1) THEN
2024: * Read the currentand PO patch levels and set the flag (that would be used to
2025: * match the Lot Number and the LPN) accordingly
2026: */
2027: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2028: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2029: l_wms_po_j_or_higher := TRUE;
2030: l_patch_j_or_higher := 'Y';
2031: IF (l_debug = 1) THEN
2032: print_debug('WMS and PO patch levels are J or higher', 4);