DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on INV_RCV_COMMON_APIS

Line 2041: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)

2037: END IF;
2038:
2039: l_transaction_identifier := p_transaction_identifier;
2040:
2041: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2042: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
2043: l_patch_level := 1;
2044: ELSE
2045: l_patch_level := 0;

Line 2042: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN

2038:
2039: l_transaction_identifier := p_transaction_identifier;
2040:
2041: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2042: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
2043: l_patch_level := 1;
2044: ELSE
2045: l_patch_level := 0;
2046: END IF;

Line 2051: IF((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)

2047: -- Get org for p_transaction_id
2048: IF p_label_type_info.business_flow_code IN (1, 2, 3, 4) THEN
2049:
2050: /* Bug# 3238878 */
2051: IF((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2052: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po)) THEN
2053: IF (l_debug = 1) THEN
2054: trace('Patchset J code ');
2055: END IF;

Line 2052: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po)) THEN

2048: IF p_label_type_info.business_flow_code IN (1, 2, 3, 4) THEN
2049:
2050: /* Bug# 3238878 */
2051: IF((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2052: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po)) THEN
2053: IF (l_debug = 1) THEN
2054: trace('Patchset J code ');
2055: END IF;
2056: OPEN rt_get_org_cur;

Line 2241: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

2237: END IF;
2238: END IF;
2239: --CLOSE get_resource_dept_code_cur;
2240:
2241: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2242: IF (l_debug = 1) THEN
2243: TRACE(' Receipt Number: ' || l_receipt_number);
2244: END IF;
2245:

Line 2253: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

2249: END IF;
2250: IF ((p_label_type_info.business_flow_code IN (1))
2251: AND (l_is_wms_org = TRUE)
2252: ) THEN
2253: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2254: -- Receipt and Inspection, WMS org, obtaining the lot information
2255: -- from the wms_lpn_contents and the rest information from the
2256: -- rti record
2257: OPEN rti_material_lpn_cur;

Line 2302: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

2298: CLOSE rti_material_lpn_cur;
2299: RETURN;
2300: END IF;
2301:
2302: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2303: IF (l_debug = 1) THEN
2304: TRACE(' Receipt Number: ' || l_receipt_number);
2305: END IF;
2306:

Line 2312: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

2308: AND (l_is_wms_org = TRUE)
2309: ) THEN
2310: -- Receipt and Inspection, WMS org, obtaining the lot information
2311: -- from the wms_lpn_contents and the rest information from the rti record
2312: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2313: OPEN rti_material_lpn_inspec_cur;
2314: FETCH rti_material_lpn_inspec_cur INTO l_inventory_item_id
2315: , l_organization_id
2316: , l_lot_number

Line 2358: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

2354: CLOSE rti_material_lpn_inspec_cur;
2355: RETURN;
2356: END IF;
2357:
2358: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2359: IF (l_debug = 1) THEN
2360: TRACE(' Receipt Number: ' || l_receipt_number);
2361: END IF;
2362:

Line 2373: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

2369: -- For putaway in WMS org and Receipt, Inspection, Delivery in INV org
2370: -- Obtain information from RTI and MTLT (if applicable)
2371: -- Receipt Inspection: No lot and seial information, print item information from RTI
2372: -- Delivery: RTI + MTLT
2373: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2374: OPEN rti_material_mtlt_cur;
2375: FETCH rti_material_mtlt_cur --INTO rti_material_mtlt_rec;
2376: INTO l_inventory_item_id
2377: , l_revision