129: , p_lot_control_code NUMBER
130: , p_serial_control_code NUMBER
131: ) IS
132: l_api_name VARCHAR2(30) := 'REMOVE_CONFIRM';
133: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
134: l_updated_count NUMBER := 0;
135: l_deleted_count NUMBER := 0;
136: BEGIN
137: x_return_status := fnd_api.g_ret_sts_success;
214: --INVCONV KKILLAMS
215: , p_secondary_quantity NUMBER DEFAULT NULL
216: --END INVCONV KKILLAMS
217: ) IS
218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219: l_api_name VARCHAR2(30) := 'BACKORDER_ONLY';
220: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
221: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
466: , p_split_sec_quantity NUMBER DEFAULT NULL
467: --END INVCONV kkillams
468: ) IS
469: l_api_name VARCHAR2(30) := 'SPLIT_ALLOCATE';
470: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
471:
472: l_txn_header_id NUMBER;
473: l_org_id NUMBER;
474: l_item_id NUMBER;
701: l_satt NUMBER;
702: l_sqr NUMBER;
703: -- END INVCONV kkilams
704: l_api_name VARCHAR2(30) := 'REPORT_CYC_CNT';
705: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
706: BEGIN
707: inv_quantity_tree_pub.query_quantities(
708: x_return_status => l_return_status
709: , x_msg_count => l_msg_count
794: l_msg_data VARCHAR2(2000);
795: l_msg_count NUMBER;
796:
797: l_api_name VARCHAR2(30) := 'REPORT_CYC_CNT';
798: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
799: /*Bug#3869184. Added the below 2 variables to hold the primary and
800: secondary reservation quantities of the existing Cycle Count Reservation*/
801: l_existing_cc_res_pri_qty NUMBER := 0;
802: l_existing_cc_res_sec_qty NUMBER := 0;
1130: , p_lot_control_code NUMBER
1131: , p_sec_missing_quantity NUMBER --INVCONV kkillams
1132: ) IS
1133: l_api_name VARCHAR2(30) := 'REPORT_CYC_CNT';
1134: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1135:
1136: CURSOR c_mmtt_info IS
1137: SELECT mmtt.organization_id
1138: , mmtt.inventory_item_id
1238: , p_transaction_temp_id IN NUMBER
1239: , p_mo_line_id NUMBER
1240: ) IS
1241: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1242: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1243: BEGIN
1244: x_return_status := fnd_api.g_ret_sts_success;
1245:
1246: IF l_debug = 1 THEN
1294: , p_transaction_temp_id IN NUMBER
1295: , p_mo_line_id NUMBER
1296: ) IS
1297: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1298: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1299: BEGIN
1300: x_return_status := fnd_api.g_ret_sts_success;
1301:
1302: IF l_debug = 1 THEN
1335: , p_transaction_temp_id IN NUMBER
1336: , p_mo_line_id NUMBER
1337: ) IS
1338: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1339: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1340: BEGIN
1341: x_return_status := fnd_api.g_ret_sts_success;
1342:
1343: IF l_debug = 1 THEN
1392: , p_lot_control_code NUMBER
1393: , p_serial_control_code NUMBER
1394: ) IS
1395: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1396: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1397: l_lot_control_code NUMBER := p_lot_control_code;
1398: l_serial_control_code NUMBER := p_serial_control_code;
1399: BEGIN
1400: x_return_status := fnd_api.g_ret_sts_success;
1492: , p_lot_control_code NUMBER
1493: , p_serial_control_code NUMBER
1494: ) AS
1495: l_api_name VARCHAR2(30) := 'PROCESS_ACTION';
1496: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1497: l_lot_control_code NUMBER := p_lot_control_code;
1498: l_serial_control_code NUMBER := p_serial_control_code;
1499: BEGIN
1500: x_return_status := fnd_api.g_ret_sts_success;
1620: --INVCONV kkillams
1621: )
1622: IS
1623: l_api_name VARCHAR2(30) := 'UPDATE_ALLOCATION_QTY';
1624: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1625: l_confirmed_quantity_primary NUMBER;
1626: l_primary_uom VARCHAR2(30);
1627: l_inventory_item_id NUMBER;
1628: l_organization_id NUMBER;