[Home] [Help]
1578: , l_api_name
1579: );
1580: END IF;
1581:
1582: DELETE mtl_allocations_gtmp;
1583:
1584: WHILE (ii <= jj)
1585: LOOP
1586:
1746: l_cur_group_num := l_cur_group_num + 1;
1747: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
1748: := l_cur_group_num;
1749:
1750: INSERT INTO mtl_allocations_gtmp
1751: ( inventory_item_id
1752: , item_number
1753: , group_number
1754: , content_lpn
1793: THEN
1794: BEGIN
1795: SELECT group_number
1796: INTO l_group_num
1797: FROM mtl_allocations_gtmp mtg
1798: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
1799: AND NVL(mtg.revision,'@@@@') = NVL(c_mmtt_rec.revision,'@@@@')
1800: AND NVL(mtg.inner_lpn,l_dum_lpn)
1801: = NVL(l_content_lpn, NVL(l_inner_lpn,l_dum_lpn))
1813:
1814: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
1815: := l_group_num;
1816:
1817: UPDATE mtl_allocations_gtmp
1818: SET primary_quantity
1819: = primary_quantity + c_mmtt_rec.primary_quantity
1820: WHERE group_number = l_group_num;
1821:
1834: l_cur_group_num := l_cur_group_num + 1;
1835: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
1836: := l_cur_group_num;
1837:
1838: INSERT INTO mtl_allocations_gtmp
1839: ( inventory_item_id
1840: , item_number
1841: , group_number
1842: , content_lpn
1900:
1901: BEGIN
1902: SELECT group_number
1903: INTO l_group_num
1904: FROM mtl_allocations_gtmp mtg
1905: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
1906: AND mtg.lot_number = c_lot_dtl_rec.lot_number
1907: AND NVL(mtg.inner_lpn, l_dum_lpn)
1908: = NVL(l_inner_lpn, l_dum_lpn)
1935: , l_api_name
1936: );
1937: END IF;
1938:
1939: UPDATE mtl_allocations_gtmp
1940: SET primary_quantity
1941: = primary_quantity + c_lot_dtl_rec.primary_quantity
1942: WHERE group_number = l_group_num;
1943: END IF;
1962: , l_api_name
1963: );
1964: END IF;
1965:
1966: INSERT INTO mtl_allocations_gtmp
1967: ( inventory_item_id
1968: , item_number
1969: , group_number
1970: , content_lpn
2023: , l_api_name
2024: );
2025: END IF;
2026:
2027: INSERT INTO mtl_allocations_gtmp
2028: ( inventory_item_id
2029: , item_number
2030: , group_number
2031: , content_lpn
2079: --
2080: BEGIN
2081: SELECT group_number
2082: INTO l_group_num
2083: FROM mtl_allocations_gtmp mtg
2084: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
2085: AND NVL(mtg.revision,'@@@@') = NVL(c_mmtt_rec.revision,'@@@@')
2086: AND NVL(mtg.inner_lpn, l_dum_lpn)
2087: = NVL(l_inner_lpn, l_dum_lpn)
2118: , l_api_name
2119: );
2120: END IF;
2121:
2122: INSERT INTO mtl_allocations_gtmp
2123: ( inventory_item_id
2124: , item_number
2125: , group_number
2126: , content_lpn
2187:
2188: BEGIN
2189: SELECT group_number
2190: INTO l_group_num
2191: FROM mtl_allocations_gtmp mtg
2192: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
2193: AND NVL(mtg.revision,'@@@@') = NVL(c_mmtt_rec.revision,'@@@@')
2194: AND mtg.inner_lpn IS NULL
2195: AND mtg.content_lpn IS NULL;
2206:
2207: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
2208: := l_group_num;
2209:
2210: UPDATE mtl_allocations_gtmp
2211: SET primary_quantity
2212: = primary_quantity + c_mmtt_rec.primary_quantity
2213: WHERE group_number = l_group_num;
2214:
2377: l_cur_group_num := l_cur_group_num + 1;
2378: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
2379: := l_cur_group_num;
2380:
2381: INSERT INTO mtl_allocations_gtmp
2382: ( inventory_item_id
2383: , item_number
2384: , group_number
2385: , content_lpn
3861:
3862: BEGIN
3863: SELECT count(*)
3864: INTO l_count
3865: FROM mtl_allocations_gtmp;
3866:
3867: IF l_debug = 1 THEN
3868: print_debug
3869: ( 'Count from mtl_allocations_gtmp: ' || to_char(l_count)
3865: FROM mtl_allocations_gtmp;
3866:
3867: IF l_debug = 1 THEN
3868: print_debug
3869: ( 'Count from mtl_allocations_gtmp: ' || to_char(l_count)
3870: , l_api_name
3871: );
3872: END IF;
3873:
3898: , serial_alloc
3899: , primary_quantity
3900: , primary_uom_code
3901: , uom_lookup_code
3902: FROM mtl_allocations_gtmp
3903: ORDER BY group_number;
3904: ELSE
3905: IF l_debug = 1 THEN
3906: print_debug
3903: ORDER BY group_number;
3904: ELSE
3905: IF l_debug = 1 THEN
3906: print_debug
3907: ( 'Invalid count of records in mtl_allocations_gtmp: '
3908: || to_char(l_count)
3909: , l_api_name
3910: );
3911: END IF;
4355: IF p_conf_uom_code IS NULL THEN
4356: OPEN x_lot_lov FOR
4357: SELECT lot_number
4358: , primary_quantity
4359: FROM mtl_allocations_gtmp
4360: WHERE inventory_item_id = p_item_id
4361: AND NVL(revision,'@@@@') = NVL(p_revision, '@@@@')
4362: AND NVL(inner_lpn,l_dum_lpn) = NVL(p_inner_lpn,l_dum_lpn)
4363: AND lot_number LIKE (p_lot_num);
4372: , p_conf_uom_code
4373: , NULL
4374: , NULL
4375: ) lot_qty
4376: FROM mtl_allocations_gtmp
4377: WHERE inventory_item_id = p_item_id
4378: AND NVL(revision,'@@@@') = NVL(p_revision, '@@@@')
4379: AND NVL(inner_lpn,l_dum_lpn) = NVL(p_inner_lpn,l_dum_lpn)
4380: AND lot_number LIKE (p_lot_num);
4421: END IF;
4422:
4423: OPEN x_serial_lov FOR
4424: SELECT serial_number
4425: FROM mtl_allocations_gtmp
4426: WHERE inventory_item_id = p_item_id
4427: AND NVL(revision,'@@@@') = NVL(p_revision, '@@@@')
4428: AND NVL(inner_lpn,l_dum_lpn) = NVL(p_inner_lpn,l_dum_lpn)
4429: AND NVL(lot_number,'@@@@') = NVL(p_lot_num, '@@@@')
9953: END IF;
9954:
9955: l_task_tbl.DELETE;
9956:
9957: DELETE mtl_allocations_gtmp;
9958:
9959: IF p_outer_lpn_done = 'TRUE'
9960: THEN
9961: IF ( (g_current_drop_lpn.multiple_drops = 'TRUE')