DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on INV_RCV_COMMON_APIS

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

2159: END IF;
2160:
2161: l_transaction_identifier := p_transaction_identifier;
2162:
2163: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2164: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
2165: l_patch_level := 1;
2166: ELSE
2167: l_patch_level := 0;

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

2160:
2161: l_transaction_identifier := p_transaction_identifier;
2162:
2163: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2164: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
2165: l_patch_level := 1;
2166: ELSE
2167: l_patch_level := 0;
2168: END IF;

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

2169: -- Get org for p_transaction_id
2170: IF p_label_type_info.business_flow_code IN (1, 2, 3, 4) THEN
2171:
2172: /* Bug# 3238878 */
2173: IF((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2174: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po)) THEN
2175: IF (l_debug = 1) THEN
2176: trace('Patchset J code ');
2177: END IF;

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

2170: IF p_label_type_info.business_flow_code IN (1, 2, 3, 4) THEN
2171:
2172: /* Bug# 3238878 */
2173: IF((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
2174: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po)) THEN
2175: IF (l_debug = 1) THEN
2176: trace('Patchset J code ');
2177: END IF;
2178: OPEN rt_get_org_cur;

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

2370: END IF;
2371: END IF;
2372: --CLOSE get_resource_dept_code_cur;
2373:
2374: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2375: IF (l_debug = 1) THEN
2376: TRACE(' Receipt Number: ' || l_receipt_number);
2377: END IF;
2378:

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

2382: END IF;
2383: IF ((p_label_type_info.business_flow_code IN (1))
2384: AND (l_is_wms_org = TRUE)
2385: ) THEN
2386: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2387: -- Receipt and Inspection, WMS org, obtaining the lot information
2388: -- from the wms_lpn_contents and the rest information from the
2389: -- rti record
2390: OPEN rti_material_lpn_cur;

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

2431: CLOSE rti_material_lpn_cur;
2432: RETURN;
2433: END IF;
2434:
2435: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2436: IF (l_debug = 1) THEN
2437: TRACE(' Receipt Number: ' || l_receipt_number);
2438: END IF;
2439:

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

2441: AND (l_is_wms_org = TRUE)
2442: ) THEN
2443: -- Receipt and Inspection, WMS org, obtaining the lot information
2444: -- from the wms_lpn_contents and the rest information from the rti record
2445: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2446: OPEN rti_material_lpn_inspec_cur;
2447: FETCH rti_material_lpn_inspec_cur INTO l_inventory_item_id
2448: , l_organization_id
2449: , l_lot_number

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

2487: CLOSE rti_material_lpn_inspec_cur;
2488: RETURN;
2489: END IF;
2490:
2491: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2492: IF (l_debug = 1) THEN
2493: TRACE(' Receipt Number: ' || l_receipt_number);
2494: END IF;
2495:

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

2502: -- For putaway in WMS org and Receipt, Inspection, Delivery in INV org
2503: -- Obtain information from RTI and MTLT (if applicable)
2504: -- Receipt Inspection: No lot and seial information, print item information from RTI
2505: -- Delivery: RTI + MTLT
2506: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2507: OPEN rti_material_mtlt_cur;
2508: FETCH rti_material_mtlt_cur --INTO rti_material_mtlt_rec;
2509: INTO l_inventory_item_id
2510: , l_revision