APPS.INV_WIP_PICKING_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 554: inv_quantity_tree_pvt.clear_quantity_cache;

550: l_savept_exists := FALSE;
551:
552: l_counter := l_last_batch_rec + 1;
553: l_line_tbl.DELETE;
554: inv_quantity_tree_pvt.clear_quantity_cache;
555: END LOOP;
556: ELSE
557: -- WIP is 11.5.8 or lower
558: l_line_tbl := p_mo_line_rec_tbl;

Line 793: inv_quantity_tree_pvt.clear_quantity_cache;

789: RAISE fnd_api.g_exc_unexpected_error;
790: END IF;
791:
792: -- Bug 2038564: Clearing Qty Tree
793: inv_quantity_tree_pvt.clear_quantity_cache;
794:
795: -- Validate that all move order lines are from the same org, that all lines
796: -- have a status of pre-approved (7) or approved (3), and that all of the move
797: -- order lines are of type Manufacturing Component Pick (5)

Line 909: inv_quantity_tree_pvt.create_tree

905: END IF;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END;
908:
909: inv_quantity_tree_pvt.create_tree
910: ( p_api_version_number => 1.0
911: , p_init_msg_lst => fnd_api.g_false
912: , x_return_status => l_api_return_status
913: , x_msg_count => x_msg_count

Line 917: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode

913: , x_msg_count => x_msg_count
914: , x_msg_data => x_msg_data
915: , p_organization_id => l_organization_id
916: , p_inventory_item_id => l_mo_line.inventory_item_id
917: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
918: , p_is_revision_control => (l_revision_control_code = 2)
919: , p_is_lot_control => (l_lot_control_code = 2)
920: , p_is_serial_control => FALSE
921: , p_asset_sub_only => FALSE

Line 930: , p_exclusive => inv_quantity_tree_pvt.g_exclusive

926: , p_demand_source_delivery => NULL
927: , p_demand_source_name => NULL
928: , p_lot_expiration_date => SYSDATE
929: , x_tree_id => l_tree_id
930: , p_exclusive => inv_quantity_tree_pvt.g_exclusive
931: , p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
932: );
933:
934: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

Line 931: , p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes

927: , p_demand_source_name => NULL
928: , p_lot_expiration_date => SYSDATE
929: , x_tree_id => l_tree_id
930: , p_exclusive => inv_quantity_tree_pvt.g_exclusive
931: , p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
932: );
933:
934: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
935: RAISE fnd_api.g_exc_error;

Line 989: inv_quantity_tree_pvt.backup_tree(x_return_status => l_api_return_status, p_tree_id => l_tree_id);

985: IF (l_debug = 1) THEN
986: print_debug('Backing up qty tree: '|| TO_CHAR(l_tree_id), 'PICK_RELEASE');
987: END IF;
988: l_tree_id := l_quantity_tree_tbl(l_mo_line.inventory_item_id);
989: inv_quantity_tree_pvt.backup_tree(x_return_status => l_api_return_status, p_tree_id => l_tree_id);
990:
991: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
992: RAISE fnd_api.g_exc_error;
993: ELSIF l_api_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1068: inv_quantity_tree_pvt.restore_tree

1064: IF (l_debug = 1) THEN
1065: print_debug('Restoring Quantity Tree: '|| TO_CHAR(l_tree_id), 'PICK_RELEASE');
1066: END IF;
1067:
1068: inv_quantity_tree_pvt.restore_tree
1069: ( x_return_status => l_api_return_status
1070: , p_tree_id => l_tree_id
1071: );
1072:

Line 1256: inv_quantity_tree_pvt.clear_quantity_cache;

1252:
1253: EXCEPTION
1254: WHEN fnd_api.g_exc_error THEN
1255: ROLLBACK TO pick_release;
1256: inv_quantity_tree_pvt.clear_quantity_cache;
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1259: WHEN OTHERS THEN
1260: ROLLBACK TO pick_release;

Line 1261: inv_quantity_tree_pvt.clear_quantity_cache;

1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1259: WHEN OTHERS THEN
1260: ROLLBACK TO pick_release;
1261: inv_quantity_tree_pvt.clear_quantity_cache;
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1264: END pick_release;
1265: