[Home] [Help]
158:
159: CURSOR cur_reservable_ings
160: IS
161: SELECT d.*
162: FROM gme_material_details d, mtl_system_items i
163: WHERE d.batch_id = p_batch_id
164: AND d.line_type = -1
165: AND d.line_type = -1
166: AND ( NVL (p_timefence, 0) = 0
613: l_to_uom VARCHAR2 (3);
614: CURSOR cur_item_no (v_inventory_item_id NUMBER, v_org_id NUMBER)
615: IS
616: SELECT concatenated_segments
617: FROM mtl_system_items_kfv
618: WHERE inventory_item_id = v_inventory_item_id
619: AND organization_id = v_org_id;
620:
621: CURSOR MO_line_allocation (v_batch_id NUMBER, v_material_detail_id NUMBER)
785:
786: PROCEDURE convert_partial_to_dlr (
787: p_reservation_rec IN mtl_reservations%ROWTYPE
788: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
789: ,p_item_rec IN mtl_system_items%ROWTYPE
790: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
791: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
792: ,x_return_status OUT NOCOPY VARCHAR2)
793: IS
871:
872: CURSOR cur_batch_materials
873: IS
874: SELECT d.material_detail_id, d.batch_id, d.organization_id
875: FROM gme_material_details d, mtl_system_items_b i
876: WHERE d.organization_id = p_organization_id
877: AND d.batch_id = p_batch_id
878: AND d.line_type = gme_common_pvt.g_line_type_ing
879: AND i.organization_id = d.organization_id
1065:
1066: CURSOR cur_item_no (v_inventory_item_id NUMBER, v_org_id NUMBER)
1067: IS
1068: SELECT concatenated_segments
1069: FROM mtl_system_items_kfv
1070: WHERE inventory_item_id = v_inventory_item_id
1071: AND organization_id = v_org_id;
1072:
1073: uom_conv_error EXCEPTION;
1597: validation_error EXCEPTION;
1598: create_transaction_error EXCEPTION;
1599: detail_reservation_error EXCEPTION;
1600: uom_conversion_failure EXCEPTION;
1601: l_item_rec mtl_system_items%ROWTYPE;
1602: l_reservation_rec mtl_reservations%ROWTYPE;
1603: l_qty_convert NUMBER;
1604: l_rsv_type NUMBER;
1605: l_return_status VARCHAR2 (1);
1607:
1608: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
1609: IS
1610: SELECT *
1611: FROM mtl_system_items_b
1612: WHERE organization_id = v_org_id
1613: AND inventory_item_id = v_inventory_item_id;
1614: BEGIN
1615: IF g_debug <= gme_debug.g_log_procedure THEN
1631: CLOSE cur_fetch_item;
1632:
1633: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1634: ,'TABLE_NAME'
1635: ,'MTL_SYSTEM_ITEMS');
1636:
1637: IF g_debug <= gme_debug.g_log_statement THEN
1638: gme_debug.put_line
1639: ( g_pkg_name
1638: gme_debug.put_line
1639: ( g_pkg_name
1640: || '.'
1641: || l_api_name
1642: || ' Retrieval failure against mtl_system_items using id of '
1643: || p_material_details_rec.inventory_item_id);
1644: END IF;
1645:
1646: RAISE fetch_error;
1835: p_material_details_rec IN gme_material_details%ROWTYPE
1836: ,x_return_status OUT NOCOPY VARCHAR2)
1837: IS
1838: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1839: l_item_rec mtl_system_items_b%ROWTYPE;
1840: l_rsv_rec mtl_reservations%ROWTYPE;
1841: l_rsv_tbl gme_common_pvt.reservations_tab;
1842: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1843: l_rsv_type NUMBER;
1870:
1871: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
1872: IS
1873: SELECT *
1874: FROM mtl_system_items_b
1875: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
1876:
1877: CURSOR cur_get_mo_rec (v_move_order_line_id NUMBER)
1878: IS
2434: /* Retrieve Ingredient rows */
2435: CURSOR cur_get_reservable_ings
2436: IS
2437: SELECT d.*
2438: FROM gme_material_details d,mtl_system_items_b i
2439: WHERE d.batch_id = p_batch_rec.batch_id
2440: AND d.line_type = -1
2441: AND d.material_requirement_date < SYSDATE + NVL(gme_common_pvt.g_rule_based_resv_horizon,p_timefence)
2442: AND i. inventory_item_id = d.inventory_item_id